AD 98-21-21 R1
Registered aircraft · 85,616
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N1139ZGonet John Charles · Southwick, MAN113ABSafford Aviation Service Inc · Coolidge, AZN113AGOrban Cedric · Coral Springs, FLN113AWMontana 1 LLC · Missoula, MTN113BAPreston Richard R Trustee · Albuquerque, NMN113BEEbbinga William R · Griswold, IAN113BHBighorn Airways Inc · Sheridan, WYN113BSHill Jason A · Cody, WYN113CJMarshall Joshua · Chuckey, TNN113CMHuling Clinton D · Dutch Harbor, AKN113DPelstring Robert Michael · Santa Cruz, CAN113DFRegistered aircraftN113DRCalifornia In Nice Inc · San Jose, CAN113EJIxi LLC · West Bloomfield, MIN113FMaddox Jody S · Bouse, AZN113FSHallahan Robert J · Central Square, NYN113GAtp Aircraft 9 LLC · Wilmington, DEN113HMAkins Tal M · Register, GAN113JBMcdonald Aviation Inc · Knoxville, TNN113JCMcdonnell Bryant E · Boulder, CON113JLHare Richard C · Northville, MIN113JTAerotransplant Inc · Marfa, TXN113KKolstad Christopher Van · Galata, MTN113KRIal Corp · Lewes, DEN113LCLcd Aviation Corp · Wilmington, DEN113LSOwnship Aviation Solutions LLC · Huntsville, ALN113SGRac Global Aircraft Consulting LLC · San Marcos, CAN113SPAdvance Alarm Monitoring Inc · Paris, TXN113SWFargo Jet Center LLC · Fargo, NDN113TBBeaudoin Todd · Castleton, NYN113TRBell Thomas E · Henniker, NHN113TTHaley John R · Tomball, TXN113TWD'Antoni Gary L · Katy, TXN113VSaravis Darren S · Long Beach, CAN113VKHaskell Brenton · Georgetown, KYN113WYRyals Barry · Rhine, GAN113XClement James G · Cresson, TXN11404Kronenberger Charles · Crockett, TXN1140LLerma Michael A · Panama City, FLN1140PCromley Amanda J · Lewisburg, PAN1140QLuken Henry G III · Chattanooga, TNN1140TRegistered aircraftN1140XReaper LLC · Britton, MIN1141ALatvala Jerry B · St Simons Is, GAN1141BMiddleton Robert J · Truth Or Consequen, NMN1141KWilson Adam V · Flower Mound, TXN1141MSunshine Flyers · Auburn, CAN1141NWild Havamalt LLC · Kalispell, MTN1141UFlight School Inc · Spring, TXN1141ZMccord Geoffrey A · Tavares, FL
Back to AD 98-21-21 R1