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.
N8757SManna Anthony G · Hanover, MAN8757ULewis County Flying Club · Lewistown, MON8758QBerge Christian · Mccall, IDN8758ZBellows Paul F · Vancouver, WAN8759SCrowell Jeremy M · Arlington, WAN8759TBlack Clifton D · Newnan, GAN8759UKelly Cynthia · Sealy, TXN8759XGrald Jonathan A · Goshen, NYN8759ZHelin Bruce A Trustee · Flagstaff, AZN875CDBoca Pilot LLC · Delray Beach, FLN875CPCivil Air Patrol · Maxwell Afb, ALN875MAGould Norman L Jr · Saunderstown, RIN875PJEj Air LLC · Bel Air, MDN875RHGreat Lakes Aviation LLC N875rh · Antioch, ILN8760BManaged Aviation Inc · The Villages, FLN8760QCarcioppolo Joseph A · Auburn Twp, OHN8760TMccandless Aviation LLC · Omaha, NEN8760UReid Gary M · Medford, ORN8761TProsystems Consulting LLC · Saguache, CON8761USmith Dustin T · Jasper, GAN8761ZHaag Walter G · Fall City, WAN8762TCrook Brady G · Bandon, ORN8762UBelli Christopher J · Oregon, OHN8763BMellen Roger B · Roseburg, ORN8763GElliott Norman C · Stillwater, OKN8763QArtic Backcountry Flying Service LLC · Kotzebue, AKN8763SClinton Richard C · Fair Oaks, CAN8763XRegistered aircraftN8763ZMacdonald John R · Vancouver, WAN8764GStrait Media LLC · Anchorage, AKN8764XAdventist World Aviation · Wilson, NCN8765URebel Metals LLC · Croydon, NHN8766GGascho Wendell M · Bridgewater, VAN8766XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVN8767TReppond Richard · Sage, ARN8767XSmith Todd A · Duchesne, UTN87687Dittmer Dean C · Bennett, CON8768MRegistered aircraftN8768RBaker Scott R · Arroyo Grande, CAN8768TCarter Douglas A · Tower, MNN8768UWright Roland P · Detroit, MIN8768XBeachy Phil · Bonners Ferry, IDN8769GHeli Thrills LLC · Wills Point, TXN8769TCopper River Airmotive LLC · Copper Center, AKN8769XOmega I Corp Inc · Middletown, DEN8769ZFox Stanton C · Fairfax, VAN876CGGreen Carlton · Carmel Valley, CAN876EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN876MGAb Prop Plane II LLC · Metairie, LAN876R76r Holdings LLC · Rockport, TX
Back to AD 79-10-14 R1