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.
N46125East Carolina Aviation LLC · Camden, NCN46126Knight Kenneth D · Stoneville, NCN46128Meridian Aircraft Leasing LLC · Anniston, ALN4612BBenson Ian M · Portland, ORN4612DPrecision Flight Training Inc · Newberg, ORN4612LGrayson Clayton C · Hillsboro, TXN4612UBauman Raymond S · Douglas, WYN46130Waltzer Eric · Riverside, CAN46132N46132 Leasing LLC · Kalispell, MTN46133Baham Daniel R · Eunice, LAN4613BSutter Richard J · Kooskia, IDN4613LMcalpin Timothy P · Phoenix, AZN4613QSouth Seattle College · Seattle, WAN46143Stromme Shawn · Hazen, NDN46144Bhm Corp · Claverack, NYN4614CLinfield William K · South Lyon, MIN4614LDowell Roy · Burns, ORN4614RAltair Aircraft LLC · Gainesville, FLN4614XEdwards Dustin M · Marion, ILN46153Waldemar Mojica · Arecibo, PRN46154Spann William J · Dothan, ALN46157Gunderson Andrew C · Fond Du Lac, WIN46158Cadillac Aircraft Services Inc · Cadillac, MIN4615LBatie Matt G · Black Hawk, SDN4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeN46161Robinson Russell W · Red Feather Lakes, CON46163Bartel Christopher H · Williamsburg, PAN46166J Robert Finley & Associates Inc · Mountain Home, ARN46167Towe Lannie · Madison, ALN46168Jack Brown Seaplane Base Inc · Winter Haven, FLN4616BHammond Russell E · La Jolla, CAN4616CSan Angelo Aero L L C · San Angelo, TXN4616XDumanian Bruce C · Savannah, NYN46173Wieckowski Jan M · Grand Island, NYN46177Busch Kacie · Mesa, AZN4617BTevlin Neal · Saint Regis, MTN4617CBrookhaven Corp · Buffalo, NYN4617EState Of Michigan · Lansing, MIN4617LKellam Robert L · Georgetown, TXN46188Air Venture Flight Center · Olive Branch, MSN46189Mcdonald Gerald T · Imogene, IAN4618BRegistered aircraftN4618LCutlip Eugene F · Astoria, ORN4618XEnochs Richard L · Hartford, INN46195Wightman Randy A · Owosso, MIN46198Palmenteri Winston D · Rhome, TXN4619ARegistration Pending · Bakersfield, CARegistration pendingN4619BAnderson Scott A · Lindstrom, MNN4619LGrey Eagle Photography LLC · Battle Ground, WAN461AJRkt Productions · Bristow, VA
Back to AD 79-10-14 R1