AD 98-21-21 R1
Registered aircraft · 85,620
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.
N1430YSuess Matthew G · Rock City, ILN1431EBrandt Terry R · Hood River, ORN1431FAir Pirates Flying Club LLC · Virginia Beach, VAN1431MDmd Aviation LLC · Wilmington, NCN1431ULa Mooneytte LLC · Seabrook, SCN1431VKgrb LLC · Owensville, MON1432FMcabee Patrick A · Tampa, FLN1432MLarson Sean P · Fairbanks, AKN1432TSmith David · Belleville, ILN1432YAll Sports Aviation LLC · Cocolalla, IDN1433DWenger Arthur B · Wickenburg, AZN1433FAnderson Jesse Thomas · Phoenix, AZN1433MRegistered aircraftN1433TTilton Dave P · Bradyville, TNN1433XEchota Flyers Inc · Calhoun, GAN1434DWesner Philip F · Ashland, WIN1434FWinkelman Donald L · Anchorage, AKN1434GWagner Carl · Eagle, IDN1434TStrickland Jason · Gulfport, FLN1434YSky Hawk Partners LLC · Lugoff, SCN14350Pema Aviation LLC · Tavernier, FLN1435SGet The Noz Inc · Coeur D Alene, IDN1435TWaters Nicholas T · Claypool, INN1435YZipprich Robert A · Jacksonville, ILN14368Semeniuk Steven T · Houston, TXN1436DAsk Worldwide LLC · Ovid, MIN1436TDeland Aviation LLC · Deland, FLN1436UCloud One Flying Club Inc · Kansas City, MON14379Bas Part Sales LLC · Greeley, CON1437AWashington Adrian P · Palm Harbor, FLN1437FKelly William W · Springfield, ORN1437GMason Mark D · Brighton, CON1437HFry Dennis Charles · Anaheim, CAN1437TBenazzi Wahiba · Frisco, TXN14386Blue Star Aviation Services LLC · Shippensburg, PAN1438DOlinde Aerospace LLC · Palm Bay, FLN1438FBermudez Santana Tacito O · Conyers, GAN1438PTri Rotor Spray & Chemical · Ulysses, KSN1438SAddamo Vincent R · Porterville, CAN1438USale Reported · Greeley, COSale reportedN1438YDr Luis S Navarro Pllc · Edinburg, TXN14394Pavco Inc · Gig Harbor, WAN1439FHallock Lloyd E · Columbia, MON1439UCass Aviation LLC · Henderson, NVN1439XDovy Aviation LLC · Houston, TXN1439YGrace Aviation LLC · Fort Myers, FLN143ACPotcake Aviation LLC · Missoula, MTN143BBN62689 Inc · Middletown, DEN143BSMoses Charles · West Friendship, MDN143CPPonzo Christopher A · North Reading, MA
Back to AD 98-21-21 R1