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.

N7753WNortheastern Oregon Flying Club Inc · La Grande, ORBuilt 1964 · S/N 28-1758 N7754NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1968 · S/N 28-5201 N7754WMartin Travis James · Gladewater, TXBuilt 1964 · S/N 28-1772 N7756NSiegler Dylan Benjamin · San Mateo, CABuilt 1968 · S/N 28-5200 N7757NArmbruster Paul A · North Ridgeville, OHBuilt 1968 · S/N 28-5203 N7759WGoedecke Chris A · Whitesboro, TXBuilt 1979 · S/N 28-7916411 N775DHWheels Down Aviation LLC · Goshen, NYBuilt 1969 · S/N 32-1154 N775GParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020243 N775NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881043 N775PCMsb Aircraft LLC · Statesboro, GABuilt 1969 · S/N 28-5438 N775PPAims Community College · Greeley, COBuilt 2024 · S/N 2881783 N775TAPrice Jeffrey R · Durand, ILBuilt 1976 · S/N 28-7715108 N775XHurst Thomas W · Broken Arrow, OKBuilt 1965 · S/N 28-2951 N7761NRutter Matthew T · Arcadia, OHBuilt 1968 · S/N 28-5207 N7762NRegistered aircraftBuilt 1968 · S/N 28-5208 N7762WHenson Russell K · Santa Fe, NMBuilt 1964 · S/N 28-1761 N7763NWever Marcus L · Lincolnton, NCBuilt 1969 · S/N 28-5209 N7763WSanchez Alyse Marie · San Antonio, TXBuilt 1964 · S/N 28-1762 N7765WTri-City Aviation Inc · Hopewell, VABuilt 1964 · S/N 28-1765 N7766NKenealy Ian Patrick · San Rafael, CABuilt 1969 · S/N 28-5212 N7766WBair Dale Leroy · Canton, OHBuilt 1964 · S/N 28-1766 N7767WFinan Kevin P · Seattle, WAS/N 28-1767 N7768NLeap Frog Aviation LLC · Bentonville, ARBuilt 1968 · S/N 28-5215 N7768WKilo Niner Aviation LLC · Saint Petersburg, FLBuilt 1964 · S/N 28-1769 N7769NWoolsey Bradley W · Burleson, TXBuilt 1968 · S/N 28-5216 N7769WSeverson Michael A · Nampa, IDBuilt 1964 · S/N 28-1770 N776CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881764 N776GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881472 N776NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881044 N7770BDunning John L · East Hampton, NYBuilt 1974 · S/N 28-7515108 N7770CMcgee Ronald S · Waco, KYBuilt 1975 · S/N 28-7625083 N7770DJenkins Robert H · Kill Devil Hills, NCBuilt 1972 · S/N 28R-7235220 N7770NThompson Brad J · Pleasant View, TNBuilt 1969 · S/N 28-5217 N7770WN7770w LLC · Sheridan, WYBuilt 1964 · S/N 28-1771 N7771NSale Reported · Copper Center, AKSale reported, pending cancellationS/N 28-5218 N7771WWhitman Edward G · River Falls, WIBuilt 1964 · S/N 28-1773 N7772CCummings David P · Grayson, LABuilt 1975 · S/N 28-7625084 N7772NZmq Aviation LLC · Minneapolis, MNBuilt 1968 · S/N 28-5219 N7773NDmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 28-5221 N7773WVida Kenneth J · Harrison Township, MIBuilt 1964 · S/N 28-1776 N7774NRai Jeff · Nazareth, PABuilt 1968 · S/N 28-5222 N7775NHarris Mark · Greenville, SCBuilt 1968 · S/N 28-5223 N7776NSkylark Flight Training LLC · Wilmington, DEBuilt 1968 · S/N 28-5224 N7777WAmmon Roadable Aircraft LLC · Manchester, NHBuilt 1964 · S/N 28-1781 N7778NAsari Investments LLC · Knoxville, TNBuilt 1968 · S/N 28-5225 N7779CDicey Aviation LLC · Somerset, KYBuilt 1975 · S/N 28-7615063 N7779NPhyxsius Aviation LLC · El Paso, TXBuilt 1968 · S/N 28-5226 N7779TDavidson Thad · Whitehouse, TXBuilt 1978 · S/N 32R-7887196 N7779WHolowatsch Sergio O · Archer, FLBuilt 1964 · S/N 28-1785 N777CD777cd LLC · Rochester, MNBuilt 1978 · S/N 28R-7803255

Back to AD 87-08-08 R3