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.

N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976 N2876SRay Charlie B · Prosser, WAS/N 15066776 N2876UPianalto David · Wichita, KSBuilt 1963 · S/N 17250476 N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876 N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077 N2877CCarlson John R · Plainfield, WIBuilt 1954 · S/N 26420 N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777 N2877UMelin James · Livingston, MTBuilt 1963 · S/N 17250477 N2877XJim Doherty Trucking Inc · Sacramento, CABuilt 1967 · S/N 17700277 N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877 N2878AAero Garage Inc · Fort Myers, FLS/N 30078 N2878CGullion Joshua A · Weldona, COBuilt 1954 · S/N 26421 N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078 N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878 N2879FMinich Sophie R · Anchorage, AKS/N 18256979 N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115 N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879 N2879XGregoire Louis Bernard III · Blairsville, GABuilt 1967 · S/N 17700279 N287CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283264 N287SPRose Bros Inc · Lingle, WYBuilt 1999 · S/N 172S8239 N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183 N2880CBuchert Allen C · Grand Rapids, MNBuilt 1954 · S/N 26423 N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358 N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480 N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780 N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280 N2880YRegistered aircraftBuilt 1962 · S/N 18253880 N28811B D Aviation LLC · Sauget, ILBuilt 2004 · S/N 17281232 N2881CCompton Steven · Anchorage, AKBuilt 1954 · S/N 26424 N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981 N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081 N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881 N2881SSerbus Gary E · Olivia, MNBuilt 1967 · S/N 15066781 N28822Edwards Gordon O · Casper, WYBuilt 1966 · S/N 15063015 N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882 N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483 N2883UPaul Aviation LLC · Sault Sainte Marie, MIBuilt 1963 · S/N 17250483 N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283 N2884ADowns M Todd · De Leon, TXFirst renewal noticeBuilt 1953 · S/N 30084 N2884CKuehn Wilton H III · Turtle Lake, NDBuilt 1954 · S/N 26427 N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984 N2884KJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1979 · S/N 18053118 N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484 N2884UEast Tenn Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 17250484 N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884 N2885CCassee Udo · Anchorage, AKBuilt 1954 · S/N 26428 N2885LBlevens George A Jr · Franklin, KYS/N 17256085 N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885 N2885SWinter Thomas N · Lincoln, NEBuilt 1967 · S/N 15066785 N2885UEda4 LLC · Cresson, TXBuilt 1963 · S/N 17250485

Back to AD 79-10-14 R1