Skip to content

Registered aircraft · 54,015

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

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 N7908BFrancis James E · King City, CABuilt 1957 · S/N 29708 N7908GChamberlain Bruce H · Worcester, MABuilt 1970 · S/N 17259608 N7908TGausman Ryan O · Thorp, WABuilt 1960 · S/N 56608 N7908UBrogan Scott D · Bellevue, OHBuilt 1964 · S/N 17251908 N7908ZOnyx Performance Aviation LLC · Bakersfield, CAS/N 15060008 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 N7909XEisenhauer Lyle M · Sterling, NEBuilt 1961 · S/N 17248409 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 N79107Rosequist Christopher Conrad Trustee · Moyie Springs, IDBuilt 1973 · S/N 18261795 N7910BJohnson John A Trustee · Sandy, ORBuilt 1957 · S/N 29710 N7910GBrusse Leslie W · Enterprise, ALBuilt 1970 · S/N 17259610 N7910UStechschulte Jason P · Fort Jennings, OHBuilt 1964 · S/N 17251910 N7910VReifel Christopher · Eagle River, AKS/N 18051810 N7910ZCooper Jeffrey S · Honeoye Falls, NYBuilt 1963 · S/N 15060010 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 N7911BDaugherty Monte R · Anderson, INBuilt 1957 · S/N 29711 N7911VBig Bend Community College · Moses Lake, WABuilt 1966 · S/N 18051811 N7911XRice David L · Dickson, TNBuilt 1961 · S/N 17248411 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 N79128Hawkins Jeffery D · Mandeville, LABuilt 1973 · S/N 18261799 N7912USweet Breeze Aviation LLC · Gordonsville, VABuilt 1964 · S/N 17251912 N7912XWang Jinrao · Riverdale, GABuilt 1961 · S/N 17248412 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 N7913BLand Terry · Adamstown, MDBuilt 1957 · S/N 29713 N7913TBorsheim Richard R · Red Lodge, MTBuilt 1960 · S/N 56613 N7913UKashmir Air Inc · Somerset, NJBuilt 1976 · S/N 15077859 N7913ZBernhardt Michael J · North Branch, MNBuilt 1963 · S/N 15060013 N79140Cho Jong Hoon · Rch Palos Vrd, CAS/N 18261801 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

Back to AD 87-20-03 R2