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.
N633GEFly High LLC · Seminole, TXN633KHGrayshott Inc Trustee · Wilmington, DEN633SRTippman & Dumas Aviation LLC · Fort Wayne, INN6344YCole William G · Garner, NCN6346UN6346u LLC · Pleasant Hill, CAN6349UAirmann LLC · Mount Sterling, KYN634CHard Deck Distractions II LLC · Missoula, MTN634MGeorge Mike J · Springfield, ILN634WSun South Of Jennings LLC · Jennings, LAN634XSmg Mt LLC · Billings, MTN6353UBas Part Sales LLC · Greeley, CON6355CDutch Air LLC · Kalispell, MTN6359BRoss Stout Architect Inc · Indian Wells, CAN6359WScarlett Cameron O · Madison, WIN635MAAirswiss Inc · Wilmington, DEN635SAGrellet-Aumont Pierre A · East Quogue, NYN6364BKgnf LLC · Grenada, MSN6364CSukhakarta Rentals LLC · Cedar Park, TXN6365UPino Carlos R · Santa Fe, NMN636BERios Ralph · Chester, VAN636BTWestwind Digital Corp · Mahwah, NJN636CPurcell Dave M · Bowling Green, KYN636CTScarpone Aviation LLC · Phoenix, AZN636KBRiviera Glass Flyers Inc - Trustee · Wichita, KSN636KKKnox Construction Inc · Verdi, NVN636MRGarrison Rodney · Atlanta, TXN636RALoyd Randolph · Gassville, ARN636STDelavan Emery Lee Jr · Castroville, TXN636TCChamberlain David C · Keller, TXN636TLMasr Plane LLC · Amarillo, TXN6375XMiliano Air LLC · Lewes, DEN637BEJzl Corp · Fort Collins, CON637MRDavis Thomas H · Pt Pleasant Beach, NJN637PGBlanco Roberto C · Minneapolis, MNN6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIN6385PBada Alfredo · Mcallen, TXN6385UHilde Chadwick Q · Memphis, TNN6387UWeyermuller Scott P · Bossier City, LAN6387XAir Exec Inc · Mount Pleasant, IAN6388YMaclean Kenneth J · Northborough, MAN6389UBender & Lammers LLC · Bennington, NEN6389WSpenco Inc · Sale Creek, TNN638KBIngram Air LLC · Hahira, GAN638LLFire Island Flight LLC · Islip, NYN638PClements Scott · Royse City, TXN638SRRabidou Gary R Jr · Lancaster, MAN6391UGimli Son LLC · Fort Lauderdale, FLN6392CTretter Nicholas · Holden, MAN6395ZN Berk Consultant Inc · Greenwich, CTN6396XAviation Tech Services LLC · Edgewater, FL
Back to AD 2012-10-13