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.

N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794 N61781Ryan Good Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N 18052797 N61782Schroeder Rodger · Chugwater, WYBuilt 1977 · S/N 18052798 N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797 N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799 N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800 N61789Padilla Frank J · Vacaville, CAS/N 17264802 N6178BSeven Eight Bravo LLC · Billings, MTBuilt 1957 · S/N 34178 N6178EWaak Harlan L · Lincoln, NEBuilt 1958 · S/N 46278 N6178TRobinson Don · Peotone, ILS/N 15060878 N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724 N61792Turnbull Jason D · Wasilla, AKS/N 18052800 N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807 N61798Mayo Michael E · Boerne, TXBuilt 1978 · S/N 18053009 N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810 N6179EHolland Frederic A · Advance, NCBuilt 1958 · S/N 46279 N6179HCriss Enterprises LLC · Titusville, FLBuilt 1979 · S/N 15284139 N6179QGonzales Jerry · El Paso, TXS/N 15285185 N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104 N6179TCullipher William L · Texarkana, TXBuilt 1964 · S/N 15060879 N617MBKlinger Ronald S Trustee · Olympia, WABuilt 1977 · S/N 18503316 N617RRed Baron LLC · Middletown, DES/N 180-52979 N6180Plane Fun Inc Tr Trustee · Snellville, GAS/N 32966 N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811 N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812 N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813 N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699 N6180EUtica Township Vol Firefighter Assn Inc · Jeffersonville, INBuilt 1958 · S/N 46280 N6180KHutton Stephen · Madison, MSBuilt 1975 · S/N 15077573 N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951 N61811Schok Jr Richard N · Fairbanks, AKBuilt 1981 · S/N 18504259 N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818 N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819 N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820 N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821 N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161 N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106 N6181TFree Theta Aeronauctics LLC · Sacramento, CAS/N R18201929 N6181ZDittrich James G · Anchorage, AKBuilt 1981 · S/N U20606178 N6182Olson Gary P · Lanesboro, MNBuilt 1965 · S/N 18256342 N61822Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264822 N61825Prestage Michael J · Hondo, TXBuilt 1975 · S/N 17264824 N6182BPipkin Chester L · Boise, IDBuilt 1957 · S/N 34182 N6182TLuxaire Center Inc · Deland, FLS/N 15060882 N61832Prop Wash Aero Inc · Senoia, GABuilt 1975 · S/N 17264828 N61834Offerman Leo · Emily, MNBuilt 1975 · S/N 17264829 N61835Epic Aviation Leasing LLC · Puyallup, WAS/N 17264830 N61837Park Richard J · Devol, OKBuilt 1975 · S/N 17264831 N61839Fixen Jimmie Trustee · Lynd, MNBuilt 1975 · S/N 17264833 N6183ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1983 · S/N 18268351

Back to AD 87-20-03 R2