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.

N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N14CPWheels Floats Skids And Skis LLC · Brooklyn, MIS/N 19721 N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656 N14GLMc Flying Club Inc · Lewistown, PABuilt 1966 · S/N 15063346 N14HKTrolinger John D · Kerrville, TXBuilt 1971 · S/N 15072566 N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792 N14JMMckinstry Aviation LLC · Parker, COBuilt 1974 · S/N 18052475 N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062 N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259 N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114 N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374 N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323 N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711 N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602 N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528 N14QWDinucci Mario · Auburn, CABuilt 2006 · S/N 18281760 N14SWTriple R Ministries Inc · Crestview, FLBuilt 1974 · S/N 15075931 N14TXMcbride Robert W Jr · Mineola, TXBuilt 1963 · S/N 15060031 N14VCG5 LLC · Gallup, NMS/N 18264127 N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217 N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415 N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390 N150Beam David · Sabina, OHBuilt 1969 · S/N 15071659 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N1500QShoaff Mark · Lehigh, FLBuilt 1971 · S/N 15072800 N1500TAguilar Honorio · Anna, TXBuilt 1965 · S/N 15061784 N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354 N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197 N1501YStreeter Christopher D · Vinita, OKBuilt 1962 · S/N 17249201 N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900 N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1505QN1505q LLC · Brunswick, GAS/N 15072805 N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212 N15060Palm View Aircraft Corp · Santa Rosa Beach, FLBuilt 1960 · S/N 17941 N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356 N1506QDonald A D · Plano, TXBuilt 1971 · S/N 15072806 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507QSafety In Motion Flight Center Inc · Puyallup, WABuilt 1971 · S/N 15072807 N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903 N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882 N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357

Back to AD 79-10-14 R1