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.
N9226SSpencer Montgomery L · Clinton, SCN9227JBinns George E · Hackettstown, NJN9227MMullis Brent S · Garfield, GAN9227WMasterman Robert David · Chugiak, AKN9228DLavender James R · Gainesville, TXN9228LRegistered aircraftN9228MSteubs Mike H · Portland, ORN9228VDuval James A · Lima, OHN92296Raymes Billy F · Stedman, NCN9229CNoble Land & Cattle Inc · Albion, NEN9229DStevens Mark F · Ocean Springs, MSN9229FCooke John W III · Carthage, TXN9229JUnterschuetz Phillip David · Ladysmith, WIN9229MMadsen Jan Eric · Lincoln, NEN9229SRegistered aircraftN922AKSanderson David C · Fort Davis, TXN922CTSweptwing Holdings LLC · Houston, TXN922DDHillsboro Aero Academy LLC · Hillsboro, ORN922EAButler Ronald A · Cumming, GAN922ESSpears Esten W · Ocala, FLN922KDDoughty Robert M · Earlville, ILN922PBillester Stephen E M · Parker, CON922PWWilliams Carlton M · Big Lake, AKN922TAAtp Aircraft 4 LLC · Wilmington, DEN922TJBowar Gary R · Miranda, SDN922WSWerth Jill · Canandaigua, NYN92306High Wingers Inc · Racine, WIN92307Lowcountry Flight LLC · Johns Island, SCN9230DTbo Enterprises Inc · Chippewa Falls, WIN9230MPernick Kevin · Milford, IAN9230SSlominski Marcus A · Chapin, SCN9230TProctor Richard P · Statesboro, GAN9230VCloud Surfing Aviation LLC · Costa Mesa, CAN92318Flitepro Inc · Murrieta, CAN9231JLeetz Tom · Elgin, ILN9231VShaffer Lawrence · West Des Moines, IAN92324Pea-Wayman Flight LLC · Daytona Beach, FLN9232BLaird Charles L · Adelanto, CAN9232GHarold H Bruner · Pinehurst, IDN9232JAdirondack Flying Club LLC · Rome, NYN9232LLuquette Harley M · Abbeville, LAN9232RRogers Ricky R · Saint Francis, KSN9232TSannella Joseph J · Missoula, MTN9232VFerri Lawrence E · Lake Worth, FLN9233LGreen Samuel B · Clifton Park, NYN9233MSlone Buddie M · Waynesburg, KYN9233VRenner David C Jr · Belleville, ILN9234ACruz Salvador A · Sumter, SCN9234ELdg LLC · Kalispell, MTN9234KUnusual Attitudes LLC · Stow, OH
Back to AD 90-04-06 R1