AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N91SDFlying High LLC · Plainfield, ILN91SMCook Stephen Allen · Athens, ALN91TWPistol Aviation LLC · Stillwater, OKN91YWAurora Aviation LLC · Gettysburg, PAN91ZTTtraveler Aviation LLC · Colorado Springs, CON920AMAnderson James S · Coalinga, CAN920AWC P Daniel Properties LLC · Saint Francisville, LAN920BCTiger Express Management Company LLC · Isle Of Palms, SCN920BDBank Of Utah Trustee · Salt Lake City, UTN920CBOgden Newspapers Inc · Wheeling, WVN920EDOcs Capital Holdings LLC · White Plains, NYN920GCSabre Drilling Consulting LLC · Summerfield, NCN920GGAbbott Air Inc · Hydro, OKN920LGSmart Motion Advisory Group LLC · Frisco, TXN920MLTrammco Environmental Solutions LLC · Fernandina Beach, FLN920MMDp Aviation LLC · Trenton, NCN920NZAltura Aviation 3-Nz LLC · Waxhaw, NCN9219T19tango LLC · Newport Beach, CAN921AJAerohippo Corp · Franklin Lakes, NJN921CSN921cs Inc · Ormond Beach, FLN921DRYesmar LLC · Wilmington, DEN921EPValiair Lc Trustee · Casper, WYN921HRSeligman William P · Kennett Square, PAN921JPBoyd Air LLC · Cross Roads, TXN921KARay Aviation LLC · Carmel, INN921KTHis Aviation LLC · Spicer, MNN921REMojo Aircraft LLC · Lebanon, TNN921SKSeptember 21 LLC · Tupelo, MSN921ZF Michael Schultz LLC · Coleman, TXN9221MMiller Aviation Properties LLC · Abilene, KSN922ASSchool Of Missionary Aviation Technology · Ionia, MIN922BPTeam Leclaire LLC · Naples, FLN922CWAngel Flyers LLC · Charlottesville, VAN922KAAtlas Aviation LLC · Buckhannon, WVN922MATeton Leasing LLC · Pocatello, IDN922MHRicotta Paul J · Newton, MAN922MPPw Holdings LLC · Sulphur, LAN922PRAllred Douglas Trustee · Atherton, CAN922SE922se LLC · Fort Collins, CON922SRBorich Air LLC · Austin, TXN922TNWings Melbourne LLC · Melbourne, FLN922TWCirrus Design Corp · Duluth, MNN922VGBttw Holdings LLC · Newark, DEN923ABFloralyn Aviation LLC · East Hampton, NYN923AJRegistered aircraftN923CDCirrus 923 LLC · Peachtree City, GAN923CMContinental Aerospace Technologies Inc · Mobile, ALN923EC333 Ranch LLC · Elko, NVN923GTQuinby Tom · Memphis, TNN923MSCypress Innovations LLC · Lindenhurst, IL
Back to AD 2012-10-13