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.
N1NXBirchwood Farms Inc · Hope Mills, NCN1PAAnnis Peter · Halifax, MAN1PFTownes Patrick S · Lucerne Valley, CAN1PWWelkin Aero Inc · Garden Plain, KSN1QABender Edward C Jr · Lansdale, PAN1QQGustafson James R · Granby, MAN1RWMcmahon Jeffrey C · Iraan, TXN1SRRensberger Scott C · Lake Jackson, TXN1SXMuehl Harvey C · Macomb, MIN1SYPacific Fleet Aviation LLC · Rochester, NYN1THall George E Jr · Hillsborough, NCN1UGRegistered aircraftN1UKPenn Flight School LLC · Quakertown, PAN1VKChupito Sabrocito LLC · Paso Robles, CAN1WYBultron Cristina · Ocala, FLN1XACowell Aviation Maintenance LLC · Easley, SCN1XCTarheel Aeroplanes LLC · Macclesfield, NCN1XGClass A Coaches LLC · Missoula, MTN1XXLewis James · Los Angeles, CAN1YBPerry Billy Mac Jr · Monument, CON1ZEAdkins Gordon L · Kenova, WVN20008Crabdree Marty D · Conroe, TXN20011Fulmer Robert A · Irvine, CAN2001LSeventh LLC · Summerfield, FLN20020Nuanes Dane Scott · Missoula, MTN20023Usnick Robert W · Mc Donald, PAN2003MRoyal Timothy G · Apex, NCN2004UEpic Aviation Inc · Denison, TXN20056Haney Randall M · Boaz, ALN20067Epic Aviation Inc · Denison, TXN2006PKnox Timothy A · Tulsa, OKN2007CAviation Innovations LLC · Dover, DEN2007EWallbirds LLC · San Diego, CAN2007GRibeiro Carlos E · Vail, AZN2007KExecutive Flight Institute LLC · Murrieta, CAN2007MCritz Sue A · El Paso, TXN2007XEpic Aviation Inc · Denison, TXN20085Fleming Ian · Peoria, AZN2008BBrown William Tim · Ozark, MON2008ESchrott Bradley S · Federal Way, WAN2008TDean John W · Greentown, INN2008ZSouthern Wings Aircraft Sales Ltd · Bethany, OKN20094Valiair Lc Trustee · Casper, WYN20099Wehnam Kenneth J · Shingle Springs, CAN2009DSundowner 2009d LLC · La Place, LAN2009EAce Of Spades Aviation LLC · Las Vegas, NVN2009KMann Terry S · Farmerville, LAN2009TConcho Valley Flyers LLC · Denton, TXN2009URothe Danny L · Pawnee, ILN2009XGriffith Aviation Inc · Griffith, IN
Back to AD 2006-10-21