AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2009YFancy Pants Aviation LLC · Fort Worth, TXN200ACKerstetter Michael S · Hewitt, NJN200ADNouvel Avion LLC · Miami Gardens, FLN200AGDively Daniel R · Friedens, PAN200BBKimbrough Charles E · Pine Mountain, GAN200CARosenberg Frank D · Tempe, AZN200CEBrewer Erich J · Thompson, MON200CF200cf LLC · Decatur, ILN200CLPs Soaring Inc · Bellefonte, PAN200CTAlpha Bravo 1 LLC · Willow Street, PAN200CXPotter Aviation LLC · Milford, NJN200DBDelta Bravo Inc · Davie, FLN200DFLijack World Enterprises LLC · Winter Haven, FLN200EBBretherton Carlos F · San Luis PotosiN200EHD & M Aviation Inc · Amelia, OHN200FWNextwerk Inc · Carlsbad, CAN200HGBallou-Crawford Terry F · Enid, OKN200HMBill Keck Aviation LLC · Marlow, OKN200HUVanderhoof Chad T · Elk, WAN200JKRuiz Victor · Roscommon, MIN200KDQuantum Aero Services LLC · Wilmington, DEN200KMFabrega Teodoro A · Doral, FLN200KRDusek Ryan · Cypress, TXN200LTTraver Larry L · Sturgis, SDN200MAlliance Aircraft Group LLC · Denver, CON200MABas Part Sales LLC · Greeley, CON200MDArvelu LLC · Utica, NYN200MUIslander Holdings Ltd · Fort Lauderdale, FLN200NTRichmond Jeremy · Eufaula, OKN200P10x Aviation Partners LLC · Stuart, FLN200PJClayton Allen Heidelberg · Great Bend, KSN200PMLansing Community College · Mason, MIN200RBHollingsworth Robert D · Odessa, FLN200RFRushin William J · Greenwood, INN200RLAlpha Aviation Services LLC · Chelsea, ALN200STk Aviation LLC · Willow Street, PAN200SFRes Solutions Inc · Anderson, INN200SJChanney Aviation Group LLC · Las Vegas, NVN200SXAllen Investments Aviation & Marine Inc · Fort Myers, FLN200UHAlba Leasing Services LLC · Scottsdale, AZN200USFly More LLC · Chattanooga, TNN200VMBaker Creek Enterprise · Townsend, GAN200WAYoedhana Christian · Pflugerville, TXN200WCSigman Paul L · Incline Village, NVN200WSSierra Juliet Nm LLC · Santa Teresa, NMN200ZCTc Holdings Delaware Inc · Overland Park, KSN200ZFPhillips Robert A · Saluda, NCN2010AMaine Instrument Flight · Augusta, MEN2010CLegner Leasing LLC · Las Vegas, NVN2010LTec Consulting LLC · Farmingdale, ME
Back to AD 2006-10-21