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.
N46HDPrice Jesse · Fargo, NDN46JGKslt Aviation LLC · Birdsboro, PAN46KVPigs Aviation LLC · Houston, TXN46LAMagoon Paul J · Merrimack, NHN46MGHughes Shaun · Everett, WAN46MRDavin Matthew · Ridgecrest, CAN46MVTazzo Jet Services LLC · Jacksonville, FLN46PAAyer William S · Bellevue, WAN46PCMace Robert C Jr · Gold Canyon, AZN46TESerenity Aero LLC · Cape Girardeau, MON46TLHayes Tony George · Baton Rouge, LAN46TRWingnerds LLC · Waukesha, WIN46WBBullen Riley P · Kingman, AZN46ZELitton Enterprises Inc · Incline Village, NVN4701AWtfa LLC · Decatur, ALN470BCCorvus Flight LLC · Salinas, CAN470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PAN470STLima Charlie 2.0 LLC · Duluth, GAN4712KMclellan Bruce A Trustee · Bend, ORN4714CGorman Aviation LLC · Bartlesville, OKN4715WKelley Christopher L · La Quinta, CAN4716XJessup Sheila · Dublin, CAN4717CCt Aviation LLC · Fort Worth, TXN471FDCirrus Design Corp · Duluth, MNN471HBMyers Ralph E · San Clemente, CAN471MASwift Aviation LLC · Decatur, TNN471WMRegistered aircraftN4720CNesbit Gary M · West Linn, ORN4720PKlingler Larry R · Wolfeboro, NHN4720YKraemair Aviation LLC · Sauk City, WIN4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN4726YMeisner David B · Meridian, IDN4729CSullivan David C · St George, UTN472AGTzc LLC · Lafayette, INN472CDLorton Kenneth Patrick · Brooklyn, NYN472DVEleven A Inc Trustee · Wilmington, DEN472JJCirrus Design Corp · Knoxville, TNN472KEB Rex LLC · East Palo Alto, CAN472MBSimmons Jeffrey F · Houston, TXN472PLRiviera Aero Sales Inc · Santa Barbara, CAN472SRJuice Club Air LLC · Palm Springs, CAN4735PMarchman & Assosiates Inc · Krum, TXN473BCWaite Aviation LLC · Xenia, OHN473BJValiair Lc Trustee · Casper, WYN473CDGrupinski Stephen · Wimberley, TXN473MBProestakis Mijali N · Cypress, TXN473PRomeo Mike Properties LLC · Naples, FLN4741KCrosswind Solutions Inc · Medford, ORN4742UProtocol Enterprises LLC · Holdrege, NEN4743CFour Three Charlie LLC · Andover, MA
Back to AD 2012-10-13