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.
N11YTAnm Air LLC · Grimes, IAN11YYAerospace Trust Management LLC Trustee · Wilmington, DEN11YZHuggins David R · Carmichael, CAN12000Bear Creek Air LLC · Helena, MTN1200USowers Harry D · S Bloomingvle, OHN1200XLacola Joseph D · Commerce Township, MIN1201AByrne Michael · Fountain Hills, AZN1201FRed Door Aviation LLC · Dover, DEN1201JHall Brian E · Bedford, INN1201SFlying J Ranch Of Ocala Inc · Port Saint Lucie, FLN1201TTrudel Serge · The Woodlands, TXN1201VSchutz Ronald W · Portland, ORN1201XSimmons Herbert H Trustee · Pasadena, CAN1202BDavis Aviation Inc DBA · Brandon, MSN1202GTyler Brenda · Mountain Top, PAN1202XBrady Creative Services LLC · Forsyth, MON1203FRawson Aviation LLC · Collinsville, OKN1203TProfessional Locators & Acquisition Specialists Ll · Severance, CON1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIN1203XMcelwain Russell D · Lancaster, KSN1204FMoroney Aviation LLC · Chugiak, AKN1204THigh Sky LLC · Ellensburg, WAN1204XMcdonald Monroe · Aguila, AZN1204ZAquila Aero LLC · Denison, TXN1205BEngel Shane J · Willow, AKN1205GKnapp James Ross · Apex, NCN1205TAmerican Aircraft Management LLC · Irving, TXN1205UBordeaux Marvin · Willcox, AZN1205XOsborn Aviation LLC · Claude, TXN1206APelham Aircraft LLC · Dallas, TXN1206FHarrah Daniel R · Juneau, AKN1206TCps 1 LLC · Pelham, ALN1206XNlw 1 LLC · Washington, UTN1206ZGlg Properties LLC Series 13 · Bridgeport, TXN12077Crawley Michael P · Penn Valley, CAN1207HVenture West LLC · Mesa, AZN1207PN73481 LLC · Ault, CON1207UKasakoff Lloyd · Diamond Bar, CAN12082Lopez George · Dover, DEN1208DMusgrove James F · Burien, WAN1208FYukon Air Service Inc · Fairbanks, AKN1208HWaldel Ltd · West Lafayette, INN1208XCartaya Lazaro C · Miami, FLN1208ZMaurice L Prince Jr Pc · Lafayette, LAN12090Diaz Aviation LLC · Mount Upton, NYN12091K D Farms Inc · Cosmos, MNN12097Aerolease Aviation Rental LLC · Cartersville, GAN12098Traywick James D · Cope, SCN1209MShook Steve Trustee · Boulder, CON1209RRowley Timothy · Roopville, GA
Back to AD 98-21-21 R1