AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N8571YSkyborne Airline Academy Inc · Vero Beach, FLN8572DRubbert Jan D · Upham, NDN8572VEast Rick · Muscle Shoals, ALN8572ZSkyborne Airline Academy Inc · Vero Beach, FLN8573COcean Aerial Ads Inc · Ocean City, MDN8573JSkyborne Airline Academy Inc · Vero Beach, FLN8573VSchrack Kevin · Loganton, PAN8573XSale Reported · North Royalton, OHSale reportedN8574CVan Wagner Aerial Media LLC · Hollywood, FLN8574KSkyborne Airline Academy Inc · Vero Beach, FLN8575VMcintyre Jon D · Fairbanks, AKN8575WSkyborne Airline Academy Inc · Vero Beach, FLN8576CReser Byron G · Walla Walla, WAN8576VJam Three LLC · St George, UTN8576XSkyborne Airline Academy Inc · Vero Beach, FLN8576YCenterline Holdings LLC · Belgrade, MTN8577Burke Jeremy D · Westminster, CON8577VHoran Spraying LLC · Plainview, TXN8577YSkyborne Airline Academy Inc · Vero Beach, FLN8578Ray Christopher Kevin · Wake Forest, NCN8578CRiver Valley Flyers LLC · West Hartford, CTN8578DCoy Shane A · Nenana, AKN8578EDamrow L Bruce · Jay Em, WYN8578VNelson Timothy E · Fairbanks, AKN8578ZSkyborne Airline Academy Inc · Vero Beach, FLN8579Ralls Eddie · Evergreen, ALN8579CSolberg John W · Bismarck, NDN8579NWillaero LLC · Union City, TNN8579VWalsh Leo A Jr · Anchorage, AKN857ACToedtli Bryan S · Vancouver, WAN857ERAlpha International Aircraft Inc · Lewes, DEN857GArcher Flight LLC · Wilmington, DEN857JWWarren Joseph A · Milford, DEN857MMVigilante Helicopters LLC · Lewistown, MTN857SSjs Aviation Co · Casper, WYN857SCFf22 LLC · Scottsdale, AZN857SPSoutheastern Oklahoma State University · Durant, OKN8580DKedrowski James L · Wasilla, AKN8580ESkyborne Airline Academy Inc · Vero Beach, FLN8581ASkyborne Airline Academy Inc · Vero Beach, FLN8581DDutch Air LLC · Kalispell, MTN8581JSkyborne Airline Academy Inc · Vero Beach, FLN8581VObx Airplanes LLC · Manteo, NCN8582CCurran Aviation Services LLC · Yorba Linda, CAN8582ESkyborne Airline Academy Inc · Vero Beach, FLN8582JMarchione Laverne R · Diamondville, WYN8582MSkyborne Airline Academy Inc · Vero Beach, FLN8582VOcean Aerial Ads Inc · Ocean City, MDN8583Totorige Carson J · Glennallen, AKN8583BSkyborne Airline Academy Inc · Vero Beach, FL
Back to AD 90-04-06 R1