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.
N724CMParker Air LLC · Mobile, ALN724DEAero Air LLC · Hillsboro, ORN724KGLogan Air Services LLC · Logan, UTN724LLMorrison Aviation LLC · Dodge City, KSN724MJSend North · Anchorage, AKN724SRFlyme2 LLC · Leesburg, VAN7250NSimon Jevon · Buckley, WAN72567Hart Patrick D · Woodbridge, VAN7257NPeterson Winston Roy II · Arbuckle, CAN7258ESchreher Jeremy A · Richmond, VAN725AAMoon Flying LLC · Centreville, VAN725AKThree Juliet Tango LLC · Oakland, KYN725CDRussell Wade M Jr · Sandy Springs, GAN725CPHolmberg Bryan J · Parkland, FLN725CRWood Jeffrey · Carmel, INN725DCLubbock Wrecker Service LLC · Kalispell, MTN725EBHickory Falls LLC · Naperville, ILN725ELCirrus Sr22t 9985 Inc Trustee · Wilmington, DEN725EMLancair Corp LLC · Maitland, FLN725HBReel Altitude LLC · Hahira, GAN725KLGb&Rb Holdings LLC · Erie, PAN725LKDuluth Aviators LLC · Duluth, MNN725MPMjc LLC · Wilmington, DEN725WGPura Vida Holdings LLC · Heath, TXN725WTJ&E Adventures LLC · Conroe, TXN726BADangerstik Corp · Olympic Valley, CAN726BGDusty Bg LLC · Greensboro, NCN726CCStk Flight LLC · New Palestine, INN726CFCharlie Foxtrot Air LLC · Birmingham, ALN726DGSimms Aviation LLC · Ocala, FLN726DPGold Coast Aviation Partners LLC · Boca Raton, FLN726HSSpmhrt 206 LLC · East Bernard, TXN726KRE&E LLC · Johnston, IAN726PBN411b LLC · Griffin, GAN726PDBuchanan Thomas Steven · Hilton Head Island, SCN726PMAlpine View LLC · Williston, NDN726TJJohnstone Thomas T · Panama City, FLN726TWWallace Thomas L · Carabaset Vly, MEN726XBravo Charlie LLC · Lake Leelanau, MIN726ZMission Park Air LLC · Marion, IAN7271YVitatoe Industries Inc · Chillicothe, OHN727CDN727cd LLC · Clearwater, FLN727DHDh Consulting LLC · Newark, DEN727FValiair Ltd Co Trustee · Casper, WYN727GHBack Country Pilot LLC · Morgan, UTN727HGShirin Aviation LLC · Los Angeles, CAN727JKSky 21 LLC · Lexington, NCN727LLLaez Holdings LLC · Helena, MTN727LTFoster Jeffrey · Baton Rouge, LAN727MWAerobatics Inc Trustee · Wilmington, DE
Back to AD 2012-10-13