Skip to content

Registered aircraft · 56,579

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.

N12477South Mountain Flying Club Inc · Pittsfield, MABuilt 1973 · S/N 17262005 N12479Nielsen James R · Morgan Hill, CABuilt 1973 · S/N 17262007 N1247DWroe Daniel C · Denton, MDS/N 20119 N1247SShurma Ramesh · Hayward, CABuilt 1976 · S/N 18264816 N1247UDelari Inc · Miramar, FLBuilt 1976 · S/N 17266942 N1247YRogers Jacki-Lyn · Standish, MEBuilt 1962 · S/N 15059647 N12483Rucinski Edward A · Climax, NCBuilt 1973 · S/N 17262009 N12484Barber Brothers Rental Properties LLC · Jackson, GABuilt 1973 · S/N 17262010 N12488Davis Matthew B · Almyra, ARBuilt 1973 · S/N 17262014 N1248EBoling Derek · Paragould, ARBuilt 2005 · S/N 18281590 N1248QHeffernan Kasey C · Torrance, CAS/N 15072548 N1248SBodolay John M · Fredericksburg, VABuilt 1976 · S/N 18264817 N12492Adragna Michael G · Corfu, NYBuilt 1973 · S/N 17262017 N12493Madden Arthur F · Manville, NJBuilt 1973 · S/N 17262018 N1249SClemans Alan J · Guymon, OKBuilt 1976 · S/N 18264818 N1249UJeffries Holdings LLC · Bargersville, INBuilt 1976 · S/N 17266944 N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390 N124CKChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9808 N124DNRegistered aircraftS/N 337M0349 N124EEWisconsin Fox River Flyers Inc · Franklin, WIFirst renewal noticeS/N 172-68996 N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315 N124ERHeath Jimmie W · Columbia, SCBuilt 1986 · S/N 17276531 N124FRLauber Ronald J · Saint Louis, MOBuilt 1980 · S/N 17273814 N124HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9632 N124JRFlight World Inc · San Juan, PRBuilt 1973 · S/N 17262637 N124KChicken Hawk Aviation LLC Series 2 · Waxahachie, TXBuilt 1975 · S/N 18263803 N124KAJohnson Michael Scott · Edgewood, TXBuilt 1974 · S/N 17702181 N124LRWilson David J · Palmer, AKBuilt 1970 · S/N 18501639 N124MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8372 N124PHDk Skyhawk LLC · Park City, UTBuilt 1976 · S/N 17268084 N124PJNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1964 · S/N 17252491 N124PLL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8194 N124QKepes Bruce R · So Charleston, OHBuilt 1948 · S/N 18509 N124RCEc Aviation Inc · Stockbridge, GABuilt 1970 · S/N 17258537 N124SKAgarwal Sanjai K · Monroe, NJBuilt 2025 · S/N 18283304 N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022 N124UCLewis Robert C · Beaufort, NCBuilt 1985 · S/N 17276493 N124WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12393 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475 N124WLHomeland Aviation LLC · Shreveport, LABuilt 1979 · S/N R1723082 N124WMDenton James Manley Jr · Cabot, ARBuilt 2016 · S/N 18282431 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N12501Bahneman Todd E · Upper Marlboro, MDBuilt 1973 · S/N 17262024 N12502Flying Illini Inc · Champaign, ILBuilt 1973 · S/N 17262025 N12503Brown Eric R · Tulsa, OKBuilt 1973 · S/N 17262026 N12506Txt Aviation LLC · Deland, FLS/N 17262028 N12509Alexandria Aviation Inc · Alexandria, MNFirst renewal noticeBuilt 1973 · S/N 17262030 N1250BOstrand Aviation LLC · Mason City, NES/N R1722416 N1250DSmith Christopher R · Manvel, TXBuilt 1951 · S/N 20122

Back to AD 79-10-14 R1