Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N78927Sly David P · Nevada, IAS/N 1961 N78928Lejcar Matthew J · Cumberland Furnace, TNBuilt 1961 · S/N 1962 N7892VLambert Mathew Chase · Chapel Hill, TNBuilt 1964 · S/N 2854 N78930Klingenberg Richard A · Idaho Falls, IDBuilt 1961 · S/N 1964 N78934Harville Leonard W · Giddings, TXBuilt 1961 · S/N 1968 N78936Napier James C · San Diego, CABuilt 1962 · S/N 1970 N78937Reisen LLC · Stevensville, MTBuilt 1961 · S/N 1971 N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794 N7893GRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1970 · S/N 17259593 N7893VDarnell Noah Alexander · Searcy, ARBuilt 1964 · S/N 2855 N78940Gaskins Gregory G · Godley, TXS/N 1974 N78943Tutino John · Pleasant Valley, NYBuilt 1961 · S/N 1977 N78945Ag-Aero Services LLC · Spring Hill, FLBuilt 1962 · S/N 1979 N78946Terra Magic LLC · St Anthony, IDS/N 1980 N78949Tour Talent LLC · Akron, OHFirst renewal noticeBuilt 1961 · S/N 1983 N7894GAr Aero Services LLC · Sacramento, CABuilt 1970 · S/N 17259594 N7894VHydock David B · Leslie, ARBuilt 1965 · S/N 2937 N78953Holman Richard S · Clearmont, MOBuilt 1961 · S/N 1987 N78955Stuber Paul A · Kansas City, MOBuilt 1961 · S/N 1989 N78956Pauly Traviston · Natrona Heights, PABuilt 1961 · S/N 1990 N78959Nelson Brian · Pennsburg, PABuilt 1961 · S/N 1993 N7895SOcean Aerial Ads Inc · Berlin, MDFirst renewal noticeBuilt 1976 · S/N 586-76 N7895VCleared For Takeoff LLC · Katonah, NYBuilt 1976 · S/N 177RG0913 N78960Lydon Ethan J · Lumberton, NJBuilt 1961 · S/N 1994 N78961Schuster Christopher J · Sherman, TXBuilt 1961 · S/N 1995 N78962Smith Eric A · Kelso, WAS/N 1996 N78965Clore Gregory N · Ashland City, TNBuilt 1961 · S/N 1999 N78968Harris Rex D · Mason City, IABuilt 1962 · S/N 2142 N78972Quimby Dean Kelly · Lino Lakes, MNS/N 2006 N78975Johnson William P · Shreveport, LABuilt 1962 · S/N 2009 N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796 N78982Douglass William W III · Panora, IABuilt 1962 · S/N 2016 N78983Richard Kroll A Law Corp · Laguna Niguel, CABuilt 1962 · S/N 2017 N78984Goodin Charles R Jr · Chillicothe, OHBuilt 1962 · S/N 2018 N78987Sale Reported · Chickaloon, AKSale reportedBuilt 1962 · S/N 2021 N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598 N7898VBrown Dallas D · Taylors Falls, MNBuilt 1964 · S/N 2860 N78996Dodge Donald V · Newnan, GAS/N 2030 N78997Frederick Daniel S · Broad Brook, CTBuilt 1962 · S/N 2031 N78998Van Engen Ronald J Jr · Granbury, TXBuilt 1962 · S/N 2032 N789ACNiles Air LLC · Concord, NCBuilt 2023 · S/N 629-2023 N789CEBond Brent L · Clearwater, KSBuilt 1978 · S/N 17270536 N789GTJj Hughes Logistics LLC · Canyon, TXS/N R18200561 N789JFCoordinated Turn LLC · Fort Worth, TXBuilt 1976 · S/N 0745 N789LCEquity Property Group LLC · Welch, OKBuilt 1976 · S/N 22-1337 N789LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 1211-2024 N789MAS D 789 Partners LLC · Batavia, ILBuilt 2005 · S/N 1002-2005 N789RAMiller Melanie L · Spanaway, WABuilt 1976 · S/N 17267184 N789WEStoked Aero LLC · Camas, WABuilt 1992 · S/N 666-92 N78BYNorthwestern Michigan College · Traverse City, MIBuilt 2005 · S/N 974-2005

Back to AD 80-25-07 R1