Skip to content

Registered aircraft · 22,416

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-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N9077JStreuer Troy · Smithville, TXBuilt 1966 · S/N 28-3113 N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188 N9077WSmith Dwayne · Manassas, VAS/N 28-10677 N9078JConner W Larry · Los Lunas, NMBuilt 1966 · S/N 28-3115 N9078WWood Trey A · Colorado City, TXS/N 28-10678 N9079JTestruth Gary R · Coarsegold, CABuilt 1966 · S/N 28-3116 N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762 N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118 N9081WStickley John E · Lothian, MDBuilt 1965 · S/N 28-10683 N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011 N9082UVolar Corp · El Cajon, CAS/N 28-8616051 N9083BNorth Coast Flight School Inc · Meadville, PABuilt 1985 · S/N 28-8590076 N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050 N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174 N9083NKnoxville Flyers Inc · Knoxville, TNBuilt 1986 · S/N 28-8611005 N9084NRose John K · Guilford, CTS/N 2890164 N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122 N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175 N9085WColip Lydia · Bowling Green, INS/N 28-10689 N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123 N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176 N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014 N9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001 N9087VPyne Jeffery G · Waxhaw, NCBuilt 1986 · S/N 32R-8613005 N9087WKohlhardt Ronald C Trustee · Cameron Park, CABuilt 1965 · S/N 28-10692 N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049 N9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126 N9088QGolf Foxtrot Yankee LLC · Kingston, NYBuilt 1986 · S/N 2890002 N9088UPennington Daniel W · Rutland, VTBuilt 1986 · S/N 28-8611008 N9089K&M Land Surveying Inc · Lincoln, NEBuilt 1966 · S/N 32-215 N9089CCrew Sourcing Inc · Wilmington, DEBuilt 1985 · S/N 28-8690016 N908AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843802 N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976 N908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881946 N908DKNeilson Frank · Orlando, FLBuilt 1973 · S/N 32-7440070 N908NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881368 N9090BHaynes Aviation LLC · Wetumpka, ALBuilt 1986 · S/N 2890003 N9090WRyeco Inc · Lewes, DEBuilt 1965 · S/N 28-10696 N9090XTahaney David J · Fox Lake, ILS/N 2811001 N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197 N9092JRegistered aircraftBuilt 1966 · S/N 28-3130 N9093FArcher 93f LLC · Danvers, MABuilt 1986 · S/N 28-8690039 N9093JRichardson Harley T Jr · Mullins, SCS/N 28-3131 N9093KPdg Leasing LLC · Maryland Heights, MOBuilt 1985 · S/N 28-8690032 N9093SEllis Derek J · Austin, MNBuilt 1985 · S/N 28-8690033 N9093ZCloud Niner LLC · Furlong, PABuilt 1985 · S/N 28-8690037 N9094JDagny Aviation LLC · Gardendale, TXBuilt 1966 · S/N 28-3132 N9094KWomack-Kalla Dennis E · Philadelphia, PABuilt 1985 · S/N 28-8690034 N9095YAviation Trust Company LLC · Oklahoma City, OKS/N 32R-8529008 N9096JWingsleasing LLC · Wichita, KSBuilt 1966 · S/N 28-3136

Back to AD 87-08-08 R3