Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N79072Registered aircraftBuilt 1968 · S/N 17257861 N79079Jones Farm Fresh LLC · Bartlett, TNBuilt 1968 · S/N 17257867 N7907UReifenberger Robert A · Saint Petersburg, FLBuilt 1964 · S/N 17251907 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 N7908UBrogan Scott D · Bellevue, OHBuilt 1964 · S/N 17251908 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 N7909FK-Air Inc · Egg Harbor, WIBuilt 1966 · S/N 15064009 N7909GCopass Kaneia · Fountain Run, KYBuilt 1971 · S/N 17259609 N7909NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0300 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 N7910UStechschulte Jason P · Fort Jennings, OHBuilt 1964 · S/N 17251910 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 N7912USweet Breeze Aviation LLC · Gordonsville, VABuilt 1964 · S/N 17251912 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 N7914FPrater Stewin W · Chillicothe, OHBuilt 1966 · S/N 15064014 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 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 N7916UDillehay James L Trustee · Canyon, TXBuilt 1964 · S/N 17251916 N79172Colgan Aviation LLC · La Crosse, WIFirst renewal noticeBuilt 1969 · S/N 17257934 N79178Quonset Aero Club Inc · North Kingstown, RIBuilt 1969 · S/N 17257937

Back to AD 72-03-03 R3