Registered aircraft · 56,580

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.

N3662JDeninger William J · Northbrook, ILS/N 15064962 N3662LPrice John C · Bennington, KSBuilt 1965 · S/N 17253831 N3662UBenter Wayne D · Crosby, NDBuilt 1963 · S/N 18255062 N3663SFranks Richard W · Moville, IAS/N 17250863 N3663UWilliams James R · Austin, TXBuilt 1963 · S/N 18255063 N3663VCordova Jose F · Anaheim, CABuilt 1975 · S/N 15076578 N3663YBrown Robert Scott · Troutman, NCBuilt 1963 · S/N 21058163 N36645Kaufmann Chad · Lewiston, IDBuilt 1958 · S/N 36645 N3664LNixon Robert W · Mc Alpin, FLBuilt 1965 · S/N 17253833 N3664SWasson Tom L · Lakeport, CABuilt 1963 · S/N 17250864 N3664UAir Skylane LLC · Boulder, COBuilt 1963 · S/N 18255064 N3664VPerfect Aircraft LLC · Ocala, FLBuilt 1975 · S/N 15076579 N3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIS/N 18255065 N3665YJ & B Airlift LLC · Rupert, IDBuilt 1963 · S/N 21058165 N3666JKoseogle Ali Ozan · Longmeadow, MABuilt 1966 · S/N 15064966 N3666SBerry Mike J · Palo Cedro, CABuilt 1963 · S/N 17250866 N36674Brown Kile Executor · Dallas, TXBuilt 1965 · S/N 18256440 N3667JAbbruzze Michael J · Boynton Beach, FLBuilt 1966 · S/N 15064967 N3667SOliva Louis F III · Anchorage, AKS/N 17250867 N3667YAir Wake Aviation LLC · Hazelwood, MOBuilt 1963 · S/N 21058167 N3668CN3668c L L C · Depauw, INBuilt 1954 · S/N 31167 N3668JBrown Richard C · Adrian, MIBuilt 1966 · S/N 15064968 N3668LMaui Skyhawks Inc · Kula, HIBuilt 1965 · S/N 17253837 N3668SWm Aviation LLC · Moncks Corner, SCBuilt 1963 · S/N 17250868 N3669LNovacek Jeffrey J · Minneapolis, MNBuilt 1965 · S/N 17253838 N3669SKeller Kenneth Ray Jr · Jonesboro, ARS/N 17250869 N366CTAia Charlie LLC · Henderson, NVBuilt 2025 · S/N 172S13341 N366KWhite Thomas J · Agua Dulce, CABuilt 1957 · S/N 34529 N366MATew Services Corp · Wilmington, DEBuilt 1999 · S/N 18280596 N366METhree Six Six Mike Echo LLC · Mantua, UTBuilt 2000 · S/N 18280856 N366NHState Of New Hampshire Dept Of Safety · Concord, NHBuilt 2008 · S/N 18282106 N366STN366st LLC · Kenesaw, GABuilt 2025 · S/N 172S13331 N3670LLatch Leo D · Upland, CABuilt 1965 · S/N 17253839 N3670YRoussin David G · Newville, ALBuilt 1963 · S/N 21058170 N3671JAndrosky Charles S Jr · Superior, WIS/N 15064971 N3671LCalmet Aircraft Leasing LLC · Middletown, DEBuilt 1965 · S/N 17253840 N3672GAcosta De La Torre Armando A · El Paso, TXS/N 29549 N3672JOndrasik Peter P Jr · Palmerton, PABuilt 1966 · S/N 15064972 N3672LJanowski Stephen J Jr · Wadsworth, OHBuilt 1965 · S/N 17253841 N3672UD W Clark LLC · Newton, NJBuilt 1963 · S/N 18255072 N3672VRobinson Franz · Seagrove, NCBuilt 1975 · S/N 15076582 N3672YN3672y LLC · Ferrysburg, MIBuilt 1963 · S/N 21058172 N3673SMike Whiskey LLC · Le Claire, IABuilt 1963 · S/N 17250873 N3673VClinton Flying Service Inc · Clinton, NCBuilt 1975 · S/N 15076583 N3674JAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15064974 N3674SWiegand Gary E · Carmel Valley, CABuilt 1963 · S/N 17250874 N3675CBergstrom Dean A · Watertown, CTBuilt 1954 · S/N 31174 N3675JHarder Ronald E · Bell, FLFirst renewal noticeBuilt 1966 · S/N 15064975 N3675LSheppard Dale A · Kalispell, MTBuilt 1965 · S/N 17253844 N3675YShettle Jay E · Berryville, VABuilt 1963 · S/N 21058175

Back to AD 79-10-14 R1