AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N456RRAir America Flight Center LLC · Daytona Beach, FLN456RTMassive Solutions LLC Trustee · Denton, TXN456SGGavitt Stephen M · Rensselaer, NYN456SPAc Aviation LLC · Ocklawaha, FLN456STMcbride Ken · San Martin, CAN456TWestphal Eric R · Conroe, TXN456TGSouthern Aircraft Consultancy Inc Trustee · Casper, WYN456THB R S Leasing Inc · Wilmington, DEN456TWSchmidt Gail M · Florence, CON456UHAlba Leasing Services LLC · Scottsdale, AZN456WMWright Alfred M · Toney, ALN456WPMatagorda Production Co · Westhoff, TXN456WWJandal Group Holdings LLC · Winters, TXN456YDodson International Parts Inc · Rantoul, KSN456ZRedpole2 LLC · Kalispell, MTN4570KHead East Aviation LLC · Geneseo, ILN4570MMatthews Richard W · Kasilof, AKN4570TWinslow Dean L · Stanford, CAN4570WGuffey Jerry D · Lebanon, TNN4571BSchumacher Eraine · Hague, NDN4571TVandeventer Matthew S · Dillingham, AKN4571WBernard Scott Sr · Denham Springs, LAN4571XFly Boys Aviation LLC · Tecumseh, MIN4571YDavis James J · Beaver Dam, WIN4572AHyden William · Round Rock, TXN4572BPagel Jeffrey · Wasilla, AKN4572FRichards Stewart G · North Palm Beach, FLN4572SQualley Patrick Dion · Brooklyn Park, MNN4572WKelton Joel B · May, TXN4573FNapflin Erich P · Wasilla, AKN4573JRoss James A · Barrington, RIN4573RKaufmann Carl S · Springfield, MAN4574FKlingenmeyer Korey L · Anchorage, AKN4574JWakefield Aircraft LLC · Cooperstown, NDN4574MSweeney Thomas J · Niles, MIN4574RKing Vincent A · Grand Junction, CON4574TBas Part Sales LLC · Greeley, CON4575BKrupinshi Floyd M · Chugiak, AKN4575FSky West Aviation Inc Trustee · Albuquerque, NMN4575PWings Management Co LLC · Rio Rancho, NMN4575WN4575w LLC · Santa Fe Springs, CAN4575XPar Mar Bluffs LLC · Parker, SDN4576FDakota Aviation LLC · Sioux Falls, SDN4576KPope James Dean · Lewiston, IDN4576XElon Aviation LLC · Burlington, NCN4577Gateway Of Sturgis LLC · Sturgis, MIN4577BHorsley David L · El Paso, TXN4577LLucas John · Norco, CAN4577XFairhaven LLC · Meridian, MSN4578NAviation International LLC · El Paso, TX
Back to AD 2007-04-19 R1