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.

N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N1735DOxford Glenn H · Fredericksburg, VAS/N 20178 N1735MG & M Aircraft Inc · Wheat Ridge, COBuilt 1975 · S/N 18264421 N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035 N1735XAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10648 N1736CThompson Frank L · Weiser, IDBuilt 1953 · S/N 30436 N1736DHoffman Drew A · Churubusco, INBuilt 1951 · S/N 20179 N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682 N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714 N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718 N1737CBristol Brian P · Webster, MNBuilt 1953 · S/N 30437 N1737FVoltl Mike N · Coloma, WIS/N 17255132 N1737LZdad Aviation LLC · Little Rock, ARBuilt 2007 · S/N 18282038 N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423 N1737QWilliams Kamille N · Juneau, AKS/N 15073037 N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763 N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732 N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715 N1738CScc Aviation LLC · Caldwell, TXBuilt 2007 · S/N 18282040 N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133 N1738SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12287 N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439 N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134 N173AWLongwing Company LLC · Plymouth, MNBuilt 2022 · S/N 172S12859 N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370 N173CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283269 N173DCSkyvibe Leasing LLC · Aurora, ORBuilt 2016 · S/N 172S11720 N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939 N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781 N173LLRegistration Pending · Barrigada, GURegistration pendingBuilt 1982 · S/N 17275633 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173MEBox Aviation Inc · Montgomery, ALBuilt 2000 · S/N 172S8455 N173PBLee Bradford W · Austin, TXBuilt 2003 · S/N 172S9442 N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364 N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218 N173RJJohnston Ronald E · Seattle, WAS/N 26269 N173SKS Kamat Inc · Lexington, KYS/N 17272108 N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090 N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191 N17409Cirrus Aviation Inc · Sarasota, FLBuilt 2008 · S/N 172S10660 N1740CAmerican Aviation Inc · Brooksville, FLBuilt 2007 · S/N 172S10610 N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135 N1740TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12087 N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441 N1741MWolfehagen Paul B · Phoenix, AZS/N 33701341 N1741SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12288 N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137 N1742SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12289

Back to AD 79-10-14 R1