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.

N3511KWilkins Sy · Jacksonville, NCBuilt 1967 · S/N 28-23598 N3511TTippett Daniel W · Heath, OHBuilt 1973 · S/N 28R-7435063 N3513WFrankiewicz Victor J · Chrisman, ILBuilt 1966 · S/N 32-396 N3514KHollan Charles J · Columbia Station, OHBuilt 1967 · S/N 28-23601 N3514MCooley David Alan · Harrod, OHBuilt 1978 · S/N 28R-7803175 N3514WBattaglia Anthony · Moosic, PABuilt 1966 · S/N 32-397 N3515WHetherington Michael R · Fairbanks, AKS/N 32-398 N3516KSteitz John III · Antioch, ILS/N 28-23602 N3516MAdamsup Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32R-7885009 N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440 N351VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 28-8111056 N3520WLyttle John W Jr · Chehalis, WABuilt 1966 · S/N 32-404 N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350 N3522KAsap Realty LLC · Stroud, OKS/N 28-23608 N3523WRamunni Andrew R · Medina, OHBuilt 1966 · S/N 32-408 N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462 N3524WDiaz Albert · Ocean Springs, MSS/N 32-409 N3525WDavis Micihael K · Madison, GABuilt 1966 · S/N 32-411 N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606 N3526WN3526w Holding LLC · Harlem, GABuilt 1966 · S/N 32-412 N3527XSzmagala Taras G Jr · Bentleyville, OHBuilt 1975 · S/N 32-7540163 N3529KEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 28-23544 N352ACFlight Leasing Corp · Wilmington, DEBuilt 2006 · S/N 2842277 N352BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881692 N352MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881441 N352VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 28-7690224 N352ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881642 N3530KCook Richard A · Deshler, OHBuilt 1967 · S/N 28-23545 N3530MComer Robert E · Greensburg, INBuilt 1978 · S/N 28-7890309 N35319Yoder Electric Inc · Monticello, GABuilt 1978 · S/N 28-7816607 N35321Manuel Greg R · Pecatonica, ILBuilt 1978 · S/N 28-7816606 N3533MBrowning Gregory S · Deputy, INBuilt 1978 · S/N 28-7890311 N3534WSmittys Garage LLC · Fairmount, INBuilt 1966 · S/N 32-421 N3537KKealey William J · Redondo Beach, CABuilt 1967 · S/N 28-23614 N3539WPicard Joerg · Grand Rapids, MIBuilt 1966 · S/N 32-605 N353ACHoffberger Bruce S · Baltimore, MDBuilt 1998 · S/N 2843161 N353BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881747 N353CMIsland Air Taxi LLC · Put In Bay, OHBuilt 1976 · S/N 28-7725123 N353MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881442 N353SBurdick Steven David · Saint Paul, MNBuilt 1968 · S/N 28R-30851 N353ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881643 N3541KGauvin Daniel G · Newport, VTBuilt 1967 · S/N 28-23616 N3541WFlying Horsemen Aviation LLC · Lyons, MIS/N 32-427 N3542KJames Anthony · Lexington, NCS/N 28-23617 N3542WRockwall 6 LLC · Royse City, TXBuilt 1966 · S/N 32-428 N3543MConnor Michael B · Antioch, TNBuilt 1978 · S/N 28R-7803176 N3544KKelso Ted M · Fort Worth, TXBuilt 1967 · S/N 28-23618 N3545KMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 28-23619 N3546KPrellwitz Randy · Fairbury, NEBuilt 1967 · S/N 28-23621 N3546WMelander Dan · Summit, MSBuilt 1966 · S/N 32-433

Back to AD 87-08-08 R3