AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N4773BRegistered aircraftN4773CDickert Daniel · Cross City, FLN4773UFins Fur & Feathers Flying LLC · King Salmon, AKN4773XBlack Diamond Aviation LLC · Rathdrum, IDN4774BCunningham Martin Alden · Kansas City, MON4774EZhao Dan · New York, NYN4774FIlmberger Stephen J · Bend, ORN4775BChavez Edward C · Boise, IDN4775DHetrick-Price Willow · Anchorage, AKN4775NTennessee Metals Recycling LLC · Murray, KYN4775QShelk John Brian · Bend, ORN4775UBishop Mike · Rifle, CON4776BLarsen Christopher F · Fairbanks, AKN4776EAlpha One Aviation LLC · Dunedin, FLN4776NRegistration Pending · Ceiba, PRRegistration pendingN4776UHabberstad John L · Rathdrum, IDN4776XMersiowsky Richard R · King George, VAN4777NRosario Edwin A · Pine Island, NYN4777UAdair Aviation LLC · Broken Arrow, OKN4778EClemmons Flyers LLC · Green Cove Springs, FLN4778FPond Engineering Laboratories Inc · Berthoud, CON47793Taylor Jimmie D · Hedley, TXN4779UBergh Eugene H · Roberts, WIN4779XSnodgrass James T · Gallipolis, OHN477ALSimply Living LLC · Fort Myers, FLN477EE477ee LLC · Bethany, OKN477FReu Aviation LLC · Columbia, SCN477GFState Of Alabama Department Of Conservation · Montgomery, ALN477GYGolf Yankee LLC · Haymarket, VAN477MAThompson Layne A · Pollok, TXN4780ECarolinas Aviation LLC · North Myrtle Beach, SCN4780RR&R Flight Services Inc · Mendota, ILN4780XBroyles Dean L · Pittsboro, INN4781DGipe Douglas A · Malvern, IAN4781NRobwin Air LLC · Lutz, FLN4781QStocker Russell · Woodland, CAN4781XMartinez Ivan A · Oro Valley, AZN4782DSwalling Matthew C · Wasilla, AKN4782RSchulert Peter A · Lebanon, TNN4783BRogge Gary L · Fowler, CON4783NPlane Sense LLC · Oregon City, ORN4784BPhyfe Andrew L · Cape Coral, FLN4784EPeabody Jeffery L · Vinemont, ALN4784FSullivan Ross Anthony · Saint Helena, CAN4784XOgletree Ben R Jr · Livingston, TXN4785NHolden Engineering Inc · Oviedo, FLN4785UNew England Vascular Access LLC · Bristol, NHN4786DPierce Stephan L · Graham, TXN4786ETu Erik S · Pasadena, CAN4786FLogan Robert E · Advance, NC
Back to AD 79-10-14 R1