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.

N3769JRatner Robert D · Swan Lake, NYBuilt 1966 · S/N 15065069 N3769UNorthey Scott A · Mazama, WABuilt 1963 · S/N 18255169 N3769VSky High Investments LLC · Greenwood, INS/N 15076615 N376SPTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2003 · S/N 172S9508 N3770FSchoenberger Lance · Shakopee, MNBuilt 1966 · S/N 17255265 N3770JAzad Raja M · Hawthorne, CABuilt 1966 · S/N 15065070 N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939 N3770RBowery Michael P · Quinton, VABuilt 1966 · S/N 17255570 N3770UPetersen Christopher Erik · Morton, ILBuilt 1964 · S/N 18255170 N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270 N37718Cole Rayce S · Palmer, AKS/N 46597 N3771JKozel Thomas · Pottstown, PABuilt 1966 · S/N 15065071 N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940 N3771RMccay Brian D · Earlysville, VABuilt 1966 · S/N 17255571 N3772RRiver Town Aviation LLC · Williamstown, WVBuilt 1966 · S/N 17255572 N3772SThree Strands LLC · Colorado Springs, COBuilt 1963 · S/N 17250972 N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272 N3773JBertrand Aviation LLC · Brookville, KSBuilt 1966 · S/N 15065073 N3773RBlair Richard J · Medina, OHS/N 17255573 N3773SFielden Donald J · Bartow, FLBuilt 1963 · S/N 17250973 N3774DVandal Air LLC · Boise, IDBuilt 1957 · S/N 34474 N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943 N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274 N3775DRegistration Pending · Churchville, MDRegistration pendingS/N 34475 N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944 N3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationS/N 17255271 N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945 N3776USchmit Joe · Ventura, IAS/N 18255176 N3776VCoach Masters Inc · Kearney, NES/N 15076619 N37777Quiet Aviation LLC · Longwood, FLS/N 337-0898 N3777DOrchid Aero LLC · Lakewood, COS/N 34477 N3777VOld School Aviation · Ottsville, PABuilt 1975 · S/N 15076620 N3778DBrownd Carl L · Oro Valley, AZBuilt 1957 · S/N 34478 N3778RSwede Aviation LLC · Tucson, AZBuilt 1966 · S/N 17255578 N3778UBlue Goose Aviation Inc · Polson, MTBuilt 1964 · S/N 18255178 N3778VSmith Harold J · Poughkeepsie, NYBuilt 1975 · S/N 15076621 N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034 N3779DSeattle Glider Council Inc · Bellevue, WABuilt 1957 · S/N 34479 N3779FTiraphatna Jittakorn · Arlington, TXS/N 17255274 N3779SShawver Aviation LLC · Knoxville, IABuilt 1963 · S/N 17250979 N3779UWhittom Ronald W Jr · Wasilla, AKBuilt 1963 · S/N 18255179 N3779V212 Investments Of Montana LLC · Owasso, OKBuilt 1949 · S/N 15200 N3779YJoiner Matthew A · Temple, GABuilt 1963 · S/N 21058279 N377BAHolliday Richard A · Fort Worth, TXBuilt 1977 · S/N 177RG1245 N377CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283308 N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275 N377EPanepinto Lane P · Lafitte, LABuilt 1958 · S/N 17057 N377EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608182 N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086 N377HChupp Jeffrey L · Grove City, MNS/N 18265530

Back to AD 79-10-14 R1