Skip to content

Registered aircraft · 22,413

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.

N4015RJ And J Av8 LLC · Eatonton, GAS/N 32-40310 N4016RNorsworthy Aviation LLC · Redington Shores, FLBuilt 1967 · S/N 32-40312 N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002 N4018RRyan Jeromie · Allen, TXBuilt 1967 · S/N 32-40315 N4019RFdmas LLC · Bellevue, WABuilt 1967 · S/N 32-40316 N4019WSmith Timothy A · Granbury, TXBuilt 1966 · S/N 32-40027 N401BPSouthside Corp LLC · Rainsville, ALBuilt 2002 · S/N 3257289 N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175 N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283 N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444 N401SLCatalina Air Harbor Inc · Armuchee, GABuilt 1978 · S/N 32R-7887148 N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647 N4020RDemers James D · Firestone, COBuilt 1967 · S/N 3240297 N4020WRoss Hx LLC · Lebanon, OHBuilt 1966 · S/N 32-40029 N4021R21 Romeo Inc · Horton, MIBuilt 1967 · S/N 32-40248 N4021WClark Darrell E Jr · Edna, TXBuilt 1966 · S/N 32-40031 N4022RZ Aviation LLC · North Ridgeville, OHBuilt 1967 · S/N 32-40299 N4023FFreese Barry L · Leonardtown, MDBuilt 1976 · S/N 28-7715003 N4024JKeleti Laurie · Lakewood, NJBuilt 1975 · S/N 28-7525271 N4024RCheuvront Jevon K · Seminole, TXBuilt 1967 · S/N 32-40319 N4025WMcgee Mark K · Port Alsworth, AKS/N 32-40039 N4027FSullivan Matthew Thomas · Athens, TXBuilt 1976 · S/N 28-7790001 N4028WCmor Properties LLC · Saint Augustine, FLBuilt 1966 · S/N 32-40045 N4029WBadger 29w LLC · Waukesha, WIBuilt 1966 · S/N 32-40047 N402AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843737 N402BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020285 N402DSDelaware State University · Dover, DEBuilt 1975 · S/N 28R-7635004 N402WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 28-7790524 N4030RDsp Investments LLC · Long Beach, CABuilt 1967 · S/N 32-40325 N4032WRegistered aircraftBuilt 1966 · S/N 32-40053 N4033RSwanson Terence S · Montrose, COBuilt 1967 · S/N 32-40329 N4033WHolladay Grant L · Lamesa, TXBuilt 1966 · S/N 32-40055 N4034RBryant Jonathan E · Joaquin, TXS/N 32-40330 N4035RMoreau Donald G · Dayton, TXBuilt 1970 · S/N 28-5796 N4036RN4036r LLC · Quinton, ALBuilt 1970 · S/N 28-5663 N403ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881648 N4042RSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 32-40339 N40441Dozier Todd A · Fairfax Station, VAS/N 28R-7703306 N40449Marsan Kenan Miles · Bethel, AKS/N 32R-7780519 N4044QCloud Surfers LLC · Olathe, KSBuilt 1979 · S/N 28-7911109 N4044RFour M Aviation LLC · St Petersburg, FLBuilt 1967 · S/N 32-40342 N40451Gallego Javier · Diamond Bar, CABuilt 1977 · S/N 28-7816015 N40455Bluff Michael A · Lake Havasu City, AZBuilt 1966 · S/N 28-10785 N4048RHarris Heights LLC · Tyler, TXBuilt 1967 · S/N 32-40348 N404AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881813 N404CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881109 N404DSDelaware State Universtiy · Dover, DEBuilt 1976 · S/N 28-7615141 N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004 N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223 N404UXSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28-5423

Back to AD 87-08-08 R3