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.

N2322YIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 172S9985 N23231Jones Robert A · Smyrna, DEBuilt 1968 · S/N 15068811 N23232Ozment Dennis W · Palmyra, MOBuilt 1968 · S/N 15068812 N23237Berrong Jimmy L · Dahlonega, GABuilt 1968 · S/N 15068817 N23238Plane Simple Rentals LLC · Monroe, MIBuilt 1968 · S/N 15068818 N2323COrvin Sanden Inc · Wyndmere, NDBuilt 1953 · S/N 30623 N2323D53u Aviation LLC · Bigfork, MTBuilt 1952 · S/N 20475 N2323FMattern Rodney · Napoleon, NDS/N 21058523 N2323GLeone Daniel M · Pueblo, COBuilt 1958 · S/N 51623 N2323UBurch Daniel C · Oakdale, MNBuilt 1962 · S/N 17249923 N2323ZCalahan Spencer H · Baton Rouge, LABuilt 2023 · S/N 18283245 N23246Pripps Seth D · Appleton, WIBuilt 1968 · S/N 15068823 N23248Kainu William M · Santa Rosa, CABuilt 1968 · S/N 15068824 N2324FLong Rendell L · Woodbridge, VABuilt 1964 · S/N 21058524 N2324RKincheloe Ralph H · Jerome, IDBuilt 1964 · S/N 18255424 N2324XSchutjet Dennis · Clear Lake, IABuilt 1965 · S/N 18256224 N23251Smith Lyndsey P Trustee · Anchorage, AKBuilt 1976 · S/N 18503078 N2325FStephen N Ruark Farm Services Inc · Pantego, NCBuilt 1964 · S/N 21058525 N2325RLucky Catch LLC · Canton, MSS/N 18255425 N23261Asher Howard J · Kansas, OKBuilt 1968 · S/N 15068833 N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470 N2326DDepue Amanda N · Wasilla, AKBuilt 1952 · S/N 20478 N2326RSinger Don · Oxnard, CABuilt 1964 · S/N 18255426 N2326XFerris Elden L · Vancouver, WABuilt 1965 · S/N 18256226 N23270Simco Aviation LLC · Petal, MSBuilt 1968 · S/N 15068837 N23271Monnig Hans J · Westerville, OHBuilt 1968 · S/N 15068838 N23273Herrema Kendra L · White Cloud, MIBuilt 1968 · S/N 15068840 N23274Brogmus Rhyan P · Marana, AZBuilt 1968 · S/N 15068841 N23275West David J · Plymouth, CABuilt 1968 · S/N 15068842 N23276Spellacy Cynthia L · Seaside, CABuilt 1968 · S/N 15068843 N23277Kressin Rayh · Waunakee, WIBuilt 1968 · S/N 15068844 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N2327USprague Jeremiah A · Halfway, ORS/N 17249927 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N23284Providence Industrial Electronics Repair Inc · Pilot Mountain, NCBuilt 1968 · S/N 15068848 N23287Bocanegra Jorge S · Greenville, NCBuilt 1968 · S/N 15068851 N2328RYoung Airmans Association Inc · Arverne, NYBuilt 2005 · S/N 172S9989 N2328YRogue Air LLC · Miller, SDBuilt 1967 · S/N 17700128 N23290Walker Jeffrey · Warwick, NYBuilt 1968 · S/N 15068852 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N23295Cook Erik C · Redmond, ORBuilt 1968 · S/N 15068855 N23299King Keith L · Lexington Park, MDBuilt 1968 · S/N 15068858 N2329DSwint David A · Henderson, NVBuilt 1952 · S/N 20481 N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235 N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629 N2329RRivers Andrew · Midland Park, NJS/N 18255429 N232AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281180 N232BTHnw Aviation LLC · Melbourne, ARBuilt 1965 · S/N 15061302 N232CBLight Air Development LLC · Helena, MTBuilt 1976 · S/N 177RG0998 N232EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13095

Back to AD 79-10-14 R1