Skip to content

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.

N2511VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 18014 N25121Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13306 N25122Career Track 3 LLC · Wilmington, DES/N 172S13309 N25123Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13312 N25126Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13313 N25129Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13319 N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812 N2512JHaller David Henry Trustee · Grover Beach, CABuilt 1964 · S/N 15061012 N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712 N2512SCorsentino Joseph · Temple, TXRegistration revokedBuilt 1967 · S/N 337-0812 N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112 N2512VNichol Nathan P · Anchorage, AKS/N 18020 N25130Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13320 N25132Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13321 N25135Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13327 N25136Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13330 N25139Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13333 N2513DPetite Randall L · Lake Tapps, WABuilt 1952 · S/N 20665 N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813 N2513JT3 Flight Time Building LLC · Richmond Hill, GAS/N 15061013 N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964 N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713 N2513VMcrobie Roger L · Maryville, TNBuilt 1948 · S/N 18016 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813 N25141Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13336 N25143Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13337 N25145Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13338 N2514CPayne Jonathan R · Montgomery, ALBuilt 1954 · S/N 26158 N2514DWeindel Victoria E · Anchorage, AKBuilt 1952 · S/N 20666 N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714 N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214 N2514UHenson David C · Fort Worth, TXBuilt 1963 · S/N 17250114 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2514YBargabos Julie A · Peterboro, NYBuilt 1962 · S/N 17249814 N25150Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13339 N25152Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13342 N25153Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13345 N25157Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13348 N25158Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13351 N2515CCorbett Derek B · Durham, NCBuilt 1953 · S/N 26159 N2515DCooper Gerald W · Kennewick, WABuilt 1952 · S/N 20667 N2515JStockweather Eric A · Normal, ILBuilt 1964 · S/N 15061015 N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715 N2515VBoyd Robert T · Quakertown, PABuilt 1948 · S/N 18018 N25160Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13354 N25161Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13357 N25163Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13360 N25167Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13363 N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716

Back to AD 79-10-14 R1