AD 2001-12-01
Registered aircraft · 1,309
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:2001-12-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-12-01')
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:2001-12-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-12-01') 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.
N197LABg Family Limited Partnership · Edinburg, TXN197MAShore Air LLC · Trappe, MDN197PMRegistered aircraftN1987MPace Air LLC · Odessa, TXN199CPKbl Cvx LLC · Bellaire, MIN19CXSingle Windmill Ranch LLC · Austin, TXN19JPSheldon Law Pllc · Scottsdale, AZN1RQEnthios Enterprises LLC · Columbus, INN1WLGray William Loyd Jr · Nashville, TNN200JEBloch Gregory S · Xenia, OHN200JPBlacklist LLC · Lake Norden, SDN200WWRoark LLC · Bend, ORN201GWInternational Air Services Inc Trustee · Carson City, NVN203APHi-Tech Air Holdings LLC · Austin, TXN203CAStrasbaugh Development Corp · San Luis Obispo, CAN205APPappalardo Anthony · Vero Beach, FLN209STSky West Aviation Inc Trustee · Albuquerque, NMN20DPErvin Eric · La Follette, TNN20PCMyrtlewood Aviation LLC · Tampa, FLN20PTN20pt LLC · Wilmington, DEN2119JFour Corners Air Transit Service LLC · Aztec, NMN211MAFlames Ltd Trustee · Wilmington, DEN212KMMollet Kern · Massillon, OHN2138CAv Holding Co LLC · Polson, MTN213JPEducators Aviation LLC · Wilmington, DEN213PMLbair LLC · Hackensack, NJN215PASouthern Aircraft Consultancy Inc Trustee · Casper, WYN215SDEastern Stearman Inc Trustee · Leesburg, VAN217TSLaukatel Air Inc Trustee · Wilmington, DEN219BCArcovia Air LLC · Loganville, GAN219DL3 Wolfpack Sigma LLC · Overland Park, KSN21AGGronemeyer Jens · Deland, FLN21EPC&J Aviation LLC · Orono, MNN220UM3k Aviation LLC · Birmingham, MIN220WJaw Air LLC · Fargo, NDN221PPLive Pilot Training LLC · Ankeny, IAN221STForza Management Co · Auburn, MAN221TBSky West Aviation Inc Trustee · Albuquerque, NMN222FS404 Church LLC · Wayne, PAN222ZMPresentation Impact LLC · Sandia Park, NMN224JJCox Gerald Lee · Shepherdsville, KYN225MAAerial Services Inc · Cedar Falls, IAN225MCP46 Tango LLC · Friday Harbor, WAN227WDPowell David C · Ingram, TXN229MAN&D Executive Services LLC · San Antonio, TXN22CXMount Vernon Air LLC · Ewing, ILN22FXWoodland Aviation LLC · Belmont, MIN22MVJm Aviation Holdings LLC · Loudonville, NYN22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2313QRegistered aircraft
Back to AD 2001-12-01