Registered aircraft · 56,578

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

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

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.

N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706 N2406QSteely John R · Anderson, SCBuilt 1966 · S/N 18257606 N2406RSale Reported · Lincoln, NESale reportedBuilt 1964 · S/N 18255506 N2407GFaull James Aldo · Boise, IDBuilt 1958 · S/N 51707 N2407NPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10550 N2407RMyers William J · Colfax, WABuilt 1955 · S/N 26784 N2407UFrancis Ronald · Fredericktown, MOBuilt 1963 · S/N 17250007 N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708 N2408FDawson Brent A · Dillingham, AKS/N 18051608 N2408GEl Coyote Ranch LLC · Alzada, MTBuilt 1958 · S/N 51708 N2408JIflycali LLC · Rancho Murieta, CABuilt 1966 · S/N 15065508 N2408XWyatt David · Las Vegas, NVBuilt 1965 · S/N 18256308 N2409ENutac Leasing LLC · Deland, FLBuilt 2007 · S/N 172S10552 N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309 N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967 N240CTCoast Flight Training & Management Inc · San Diego, CABuilt 2006 · S/N 17281352 N240DCWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281099 N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757 N240LMChamblis John L · Webb, MSBuilt 1966 · S/N 18257601 N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168 N24108Svetfur Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10504 N2410CChasin Tails Inc · Gouldsboro, MEBuilt 1954 · S/N 30710 N2410DWeaver James C · Boise, IDFirst renewal noticeBuilt 1952 · S/N 20562 N2410EKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17271272 N2410JHeinze Gregory L · Little Rock, ARBuilt 1966 · S/N 15065510 N2410LSammons Mitchell · Belgrade, MEBuilt 1966 · S/N 17255610 N2410QRegistered aircraftBuilt 1966 · S/N 18257610 N2410UYellow Breast Aviation LLC · Christiansted, VIS/N 17250010 N2410XKitsap Aviation Squadron · Southworth, WABuilt 1965 · S/N 18256310 N2411CMacadams Christopher L · Bloomington, MNS/N 30714 N2411DBinsky Lawrence A · Bexley, OHS/N 20563 N2411JKenney Jason M · Grand Rapids, MIBuilt 1966 · S/N 15065511 N2411LEfinger John M · Cresson, TXS/N 17255611 N2411RLowery Jerry W · Cartersville, GABuilt 1964 · S/N 18255511 N2411USiemens Jonathan Lee · Seminole, TXBuilt 1963 · S/N 17250011 N2411YMullings Michael A · Orange, NJBuilt 1962 · S/N 17249711 N2412CRigid Oilfield Services LLC · El Reno, OKS/N 30712 N2412QTickemyer David K · Warrensburg, MOBuilt 1966 · S/N 18257612 N2412UHill Brock E · Palouse, WABuilt 1963 · S/N 17250012 N2412WWestern Edge Aviation LLC · Dickinson, NDBuilt 2007 · S/N 172S10557 N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713 N2413UAmazon Aero Corp · Wilmington, DES/N 17250013 N2413YRegistration Pending · Bangor, MERegistration pendingS/N 17249713 N24143Angel Aviation Inc · Peoria, AZS/N 55436 N24144Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10558 N2414DSmith Nathias N · Weiser, IDS/N 20566 N2414URozell Wallace R · Argyle, TXBuilt 1963 · S/N 17250014 N2414YHigh Flight LLC · Casey, ILBuilt 1962 · S/N 17249714 N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094 N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290

Back to AD 79-10-14 R1