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.
N678HCMckisson Holdings LLC · Renton, WAN678JKCirrus Design Corp · Duluth, MNN678JSGolden Pegasus LLC · Hughson, CAN678PCComplete Rv LLC · Kalispell, MTN678PGDbar N881pg LLC · San Angelo, TXN678PHOctothorpe Aero LLC · Kennesaw, GAN678SBTvpx Ars Inc Owner Trustee · North Salt Lake, UTN678SRDc Air LLC · Dover, DEN678TCRfpc Properties LLC · Nashville, TNN678TX22t-10617 LLC · Austin, TXN678ZBas Part Sales LLC · Greeley, CON67909Hyannis Air Service Inc DBA · Hyannis, MAN6792GGrimmett Donna G · Tomball, TXN6797YFar West Ranches Inc · Brawley, CAN679BJPpcm LLC · Altamonte Springs, FLN679CDHsc Aviation LLC · Gig Harbor, WAN679JBLaughing Giraffe Aviation LLC · Millsboro, DEN679LMLone Mountain Aircraft LLC · Vandalia, OHN67ALAlan Gaudenti · Groveland, CAN67AMR&R 22t1 LLC · Wilmington, DEN67CDAspen Aircraft LLC · Oklahoma City, OKN67CHPrestige Aviation LLC · Lake Havasu City, AZN67DFSusens Dennis W · Columbia Falls, MTN67EPViner Kevin Patrick · Encinitas, CAN67ERWhitfield Michael L · Leander, TXN67GSMcmillian William C · Reno, NVN67GXDivision Of Aerodynamics LLC · Littleton, CON67JDSchweizer Jack · Grants Pass, ORN67MZMain Flyer LLC · Fort Lauderdale, FLN67PKNexsys Eletronics Inc · Independence, ORN67RKRiley Matthew · Xenia, OHN67RZModular Aviation LLC · Saratoga Springs, UTN67SAE And J Medical Consulting LLC · Lima, OHN67TZKac Air LLC · Rindge, NHN67VMCreeque Alley Ventures LLC · Missoula, MTN67ZTJazzz Air LLC · Arvada, CON68007N68007 LLC · Stratford, CTN6801THoffman Peter · Monrovia, CAN680PBoren John D · Martinsville, INN680SBSair LLC · Carmel, INN680SCCotton Row Aviation LLC · Hilton Head Island, SCN6814RBbc414a LLC · Alton Bay, NHN6815TL A Flyers LLC · Monticello, ARN6816BMystic Dreams LLC · Mount Juliet, TNN6817DGlasscock Charles W Jr · Elm Grove, LAN6818XBlue Skys Aero LLC · Vermilion, OHN681CWalker Jabir Salim · Louisville, KYN681CDSwift Bruce I · Ambler, PAN681JKBirdwell Jarrod · Houston, TXN681MBBerger James B · Warrenton, VA
Back to AD 2012-10-13