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.

N5621UMeinert Kyle L · Cottage Grove, WIBuilt 1969 · S/N 28-26417 N5621WHurt Bret K · Huntsville, ALBuilt 1962 · S/N 28-764 N56220Seashell Aviation LLC · Milton, FLS/N 28-7325591 N56224Thomas Way LLC · Jackson, MIBuilt 1973 · S/N 28-7305554 N56227Registration Pending · Ira, MIRegistration pendingBuilt 1973 · S/N 28-7305555 N5622KAyorinde Olawale T · Upper Marlboro, MDBuilt 1973 · S/N 28-7305556 N56231Leber Oliver P · Spanish Fort, ALBuilt 1973 · S/N 28-7310173 N56239Hobart Aviation Inc · Akron, OHS/N 28-7325593 N5623UMendoza Cesar · Anthony, NMBuilt 1969 · S/N 28-26419 N5623VRedland Aviation LLC · Plain Dealing, LAFirst renewal noticeBuilt 1977 · S/N 28R-7703137 N56241Smith Bonny L · Milan, INBuilt 1973 · S/N 28-7305558 N56247Aviair Corp · Tequesta, FLBuilt 1973 · S/N 28R-7335391 N56256Flying Bears Aviation LLC · Wilmington, DEBuilt 1973 · S/N 28-7305559 N5625USkorina Air LLC · Walla Walla, WABuilt 1969 · S/N 28-26421 N56264Fingerlakes Aviation LLC · Marietta, NYBuilt 1975 · S/N 28R-7535212 N5626UFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26423 N5626WMiller Andy · Marana, AZBuilt 1962 · S/N 28-769 N56277Lightfoot John A · Hagerstown, MDBuilt 1973 · S/N 32-7300056 N5627FFolger Alfred J · Columbia, SCBuilt 1976 · S/N 28-7715144 N5627UMcelhannon Susan L · Athens, GABuilt 1969 · S/N 28-26422 N5627VAraujo Richard · Westport, MAS/N 32-7740070 N5627WSavio Stefan V · Trophy Club, TXBuilt 1962 · S/N 28-772 N56280Briggs Samuel K · Portland, ORBuilt 1973 · S/N 28-7325597 N56281Lewis Nathan Timothy · Hayden, IDS/N 28-7325598 N56282Kowatra Anil K · Lilburn, GAS/N 28-7325601 N56283Stephens Donald K · Modesto, CABuilt 1973 · S/N 28R-7335399 N56285Knots And Attitudes LLC · Wimberley, TXBuilt 1973 · S/N 32-7340168 N56288Cole Douglas W · Kennewick, WAS/N 28-7325604 N56289Butler Stephen P · Ossian, INBuilt 1973 · S/N 28-7305564 N5628FHobbs Jason · Saint Francisville, LABuilt 1976 · S/N 28-7715145 N5628WB & D Aviators LLC · Bremen, INBuilt 1962 · S/N 28-773 N5629WLawrence Michael · Eden Prairie, MNBuilt 1962 · S/N 28-774 N562AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881814 N562CAG Gil Aviation Services LLC · Pompano Beach, FLBuilt 1977 · S/N 32-7840043 N562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 2842104 N562TCThekkekandam Thomas J · Greensboro, NCBuilt 1977 · S/N 32R-7880052 N562TRBig Dream LLC · Memphis, TNBuilt 2007 · S/N 3257453 N56309Des Jardins Richard T · St Joseph, MIBuilt 1973 · S/N 327300059 N56313Markel John E · Sussex, NJBuilt 1973 · S/N 28R-73-35407 N56317Flying Doctor LLC · Clearwater, FLBuilt 1973 · S/N 28R-7335410 N5631UTejada Emilia P · Oakland Park, FLS/N 28-26427 N56320Merry Peter · Franklin, TNBuilt 1973 · S/N 32-7300057 N56324De Melo Marcelo Ramos · Vinton, VABuilt 1973 · S/N 287325609 N56325Glaser John · Merritt Island, FLBuilt 1973 · S/N 28-7305570 N56326Abernathy Spraying Service Inc · Tipton, OKBuilt 1973 · S/N 28R7335409 N5632USale Reported · Montgomery, ALSale reportedBuilt 1969 · S/N 28-26428 N56339N56339 LLC · Lebanon, OHBuilt 1973 · S/N 28R7335414 N5633VMcwilliams Stephen C · Hollywood, MDBuilt 1977 · S/N 32R-7780349 N5633WWenzel Mark B · Algona, IABuilt 1962 · S/N 28-779 N56340Mja Aviation LLC · Channahon, ILBuilt 1973 · S/N 327340173

Back to AD 87-08-08 R3