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.

N3760WTonini Ryan · Huntsville, ALS/N 32-677 N3761THupp Michael A · Marietta, OHBuilt 1967 · S/N 28R-30070 N3762TBenson Robert W · Iowa Park, TXBuilt 1967 · S/N 28R-30073 N3763KRyback Andrew · Ocala, FLBuilt 1967 · S/N 28-23722 N3763TGorey Chase · Saint Augustine, FLBuilt 1967 · S/N 28R-30074 N3763WDaise Nicklaus J · West Chester, PABuilt 1966 · S/N 32-681 N3765MReyner Mark D · Los Lunas, NMBuilt 1978 · S/N 28R-7803191 N3765THakanson Paul J · Norway, MEBuilt 1967 · S/N 28R-30076 N3765WMazzochi James A · Hilton Head Island, SCBuilt 1966 · S/N 32-685 N3767QParsons John C · Wichita, KSBuilt 1977 · S/N 32R-7780322 N3767TFd Equipment Rentals · Sacramento, CAS/N 28R-30078 N3768TLofranco Homes LLC · Saratoga Springs, NYBuilt 1967 · S/N 28R-30080 N3769MWillard John E · Rockwood, MEBuilt 1978 · S/N 32R-7885014 N3769T69 Tango Flying Club · Aliquippa, PAFirst renewal noticeBuilt 1967 · S/N 28R-30081 N376AAWittig Larry A · Tamaqua, PAS/N 32R-7885094 N376HCMfd Aviation Inc · Middletown, DEBuilt 1976 · S/N 32R-7680322 N376HPGray Martin E · Webster, NYS/N 3257328 N376JSNeighbors Matthew Dean · Skiatook, OKBuilt 1979 · S/N 28-7916376 N3770TWashburn James F · Cochran, GABuilt 1967 · S/N 28R-30082 N3772MClear2aviate LLC · Ionia, MIBuilt 1978 · S/N 28-7890331 N3772WBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1966 · S/N 32-694 N3773TVos Real Estate LLC · Holland, MIBuilt 1967 · S/N 28R-30085 N3775RBack Mark D · Washington, DCBuilt 1970 · S/N 28-5818 N3777TStewart Donald J · Palm City, FLBuilt 1967 · S/N 28R-30089 N3778TVan De Vanter Robert A · Paso Robles, CAS/N 28R-30090 N3779TShultz Martin · Naperville, ILBuilt 1967 · S/N 28R-30091 N3779WAirmotive Service LLC · Brigham City, UTBuilt 1966 · S/N 32-701 N377KHGeneration Investments LLC · Provo, UTBuilt 1988 · S/N 2890079 N377LCLane Community College · Eugene, ORS/N 28R-7918120 N377RTElevated Aviation LLC · Silt, COS/N 3257377 N377SMJrt Flying Co · Roanoke, VABuilt 1977 · S/N 32R-7780223 N3780TBowley Leonard · Newton, ALBuilt 1967 · S/N 28R-30092 N3780WRaines Marshall A Jr · Whiteside, TNBuilt 1966 · S/N 32-702 N3781KBomar Tami J · Gig Harbor, WABuilt 1967 · S/N 28-23728 N3782RFreeman William B Jr · Southington, CTBuilt 1970 · S/N 28-5824 N3784KBurr Walter E · Tecumseh, MIBuilt 1967 · S/N 28-23729 N3784WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 32-707 N3785TZeuner John F · Austin, TXBuilt 1967 · S/N 28R-30098 N3786TSunrise Aviation Inc · Ormond Beach, FLBuilt 1967 · S/N 28R-30099 N3786WDavis William K · Fredericksburg, VABuilt 1966 · S/N 32-709 N3788TMason Kenneth Lee · Siloam Springs, ARBuilt 1967 · S/N 28R-30101 N3789TGullett John H II · Jacksonville, FLBuilt 1967 · S/N 28R-30102 N378BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881778 N378BPBlue Sky Education Inc · Louisville, KYBuilt 1964 · S/N 28-1547 N378HPBelair Venice Aviation LLC · Osprey, FLBuilt 2004 · S/N 3257347 N378JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020078 N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239 N3790WScudder Adam J · Orlando, FLS/N 32-715 N3791QArcher Aviation · Towson, MDS/N 28-7790466 N3791TMakowski Edward J · Barberton, OHBuilt 1967 · S/N 28R-30104

Back to AD 87-08-08 R3