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.

N79081James Ferrick · Mechanicville, NYBuilt 1968 · S/N 17257869 N79086Marshall County Flying Club Inc · Lacon, ILBuilt 1968 · S/N 17257870 N79087Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 17257871 N79089Ramaswamy Gautam · Clearwater, FLBuilt 1968 · S/N 17257872 N7908GChamberlain Bruce H · Worcester, MABuilt 1970 · S/N 17259608 N79090Caughman John R · Katy, TXBuilt 1968 · S/N 17257873 N79092Aero Quest LLC DBA · Olive Branch, MSBuilt 1968 · S/N 17257874 N79093Bray Austin M · Pontotoc, MSBuilt 1968 · S/N 17257875 N79095Hole In The Clouds Rentals LLC · Montgomery, ALBuilt 1969 · S/N 17257877 N7909GCopass Kaneia · Fountain Run, KYBuilt 1971 · S/N 17259609 N790LLetourneau University · Longview, TXBuilt 2011 · S/N 1408-2011 N79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHBuilt 1969 · S/N 17257882 N79104Roman Nose Flying Club Inc · Newalla, OKBuilt 1969 · S/N 17257884 N79105Linn Nicholas D · Norfolk, NEBuilt 1969 · S/N 17257885 N7910GBrusse Leslie W · Enterprise, ALBuilt 1970 · S/N 17259610 N79113Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17257889 N79118Osceola Aerosport LLC · Osceola, WIBuilt 1969 · S/N 17257893 N79119Carr Randal J · Chandler, OKBuilt 1969 · S/N 17257894 N79122Johnson John C · Squaw Valley, CABuilt 1969 · S/N 17257896 N79125Brekhus Palmer A · Tolley, NDBuilt 1969 · S/N 17257897 N79126Grounded Hangar Inc · Turlock, CABuilt 1969 · S/N 17257898 N79130M&M Shipshape LLC · Kalispell, MTBuilt 1969 · S/N 17257901 N79133Rotate LLC · Eden Prairie, MNBuilt 1969 · S/N 17257903 N79136Registered aircraftBuilt 1969 · S/N 17257906 N79137Marshall Jeffery K · Pleasanton, CABuilt 1969 · S/N 17257907 N79139Manifee Doris Darlene · Black Canyon City, AZBuilt 1969 · S/N 17257909 N79142Nelson Tyler J · Hermantown, MNBuilt 1969 · S/N 17257912 N79144Card Kevin R · Ormond Beach, FLBuilt 1969 · S/N 17257913 N79145Hillestad Darrell L · Aberdeen, SDBuilt 1969 · S/N 17257914 N79146Deguzman Arien L · Tomball, TXBuilt 1969 · S/N 17257915 N79147Donnelly Jennifer A · Hackettstown, NJBuilt 1969 · S/N 17257916 N7914GKai Aviation LLC · San Jose, CABuilt 1970 · S/N 17259614 N79150Registration Pending · Newark, DERegistration pendingBuilt 1969 · S/N 17257919 N79155Donnelly Thomas E · Salome, AZBuilt 1969 · S/N 17257921 N79159Lehn James M · Park Rapids, MNS/N 17257924 N79162Fink Roland Jr · Berlin, MDBuilt 1976 · S/N 17268132 N79163Johnson Richard E · Columbiana, OHBuilt 1969 · S/N 17257928 N79164N8389u LLC · Monument, COBuilt 1969 · S/N 17257929 N79169Lapp Thomas A · Homer, AKBuilt 1969 · S/N 17257932 N7916GOgles Danny Lee · Elk City, OKBuilt 1970 · S/N 17259616 N79172Colgan Aviation LLC · La Crosse, WIFirst renewal noticeBuilt 1969 · S/N 17257934 N79178Quonset Aero Club Inc · North Kingstown, RIBuilt 1969 · S/N 17257937 N7917SNelson Cliff A · Joplin, MTBuilt 1976 · S/N 943-76 N79184Kearns Capital Holdings LLC · Nampa, IDBuilt 1969 · S/N 17257941 N79187Registration Pending · San Mateo, CARegistration pendingBuilt 1969 · S/N 17257943 N79189Norman Ryan C · Woodstock, CTBuilt 1969 · S/N 17257945 N7918SKnox James P · Park Rapids, MNBuilt 1976 · S/N 955-76 N79191Kirkland Patrick C Sr · North Augusta, SCBuilt 1969 · S/N 17257947 N79195Williams James W · Danbury, CTBuilt 1969 · S/N 17257949 N79197Goheen Gordon C · Battle Ground, WABuilt 1969 · S/N 17257951

Back to AD 80-25-07 R1