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.

N5558FConner Brad S · Waynesville, OHBuilt 1968 · S/N 28-24898 N5558WPatterson Troy V · Arlington, TXS/N 28-650 N55593Flying Life LLC · Fuquay Varina, NCBuilt 1973 · S/N 28-7305400 N55596Outdoor Products Of Louisiana LLC · Heflin, LAS/N 28-7325439 N55597Arndt Douglas E · Marion, WIBuilt 1973 · S/N 28-7305421 N55598Smith Gregory E · Manila, ARS/N 28-7305422 N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256 N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899 N555AMEdgewater Ventures LLC · Friday Harbor, WABuilt 1978 · S/N 32R-7885187 N555AZN555az LLC · Herndon, VABuilt 1969 · S/N 28-26585 N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254 N555BPBayusik Kevin R · Shelton, CTBuilt 1980 · S/N 32R-8029072 N555CAFigueiredo William A · Riverside, CABuilt 1974 · S/N 28-7415139 N555DLSchaben Justin · Dunlap, IAS/N 32-7940103 N555EEKielich Darryl C · Knights Landing, CABuilt 1968 · S/N 28-24888 N555FLD&J Aviation LLC · Apopka, FLBuilt 1971 · S/N 28-7125394 N555GMDavis Scott · Morse, TXBuilt 1968 · S/N 28-11010 N555HAYasko Gary R · Gallipolis, OHBuilt 1978 · S/N 28-7916125 N555JLSearles Warren Jr F · Pittstown, NJBuilt 1978 · S/N 32-7840144 N555JMFingerlakes Area Pilots Inc · Seneca Falls, NYBuilt 1979 · S/N 28-7916412 N555KLShemenski Aaron J · Tiverton, RIBuilt 1974 · S/N 28R-7535044 N555NAWe Warrior Three LLC · Paragould, ARBuilt 1974 · S/N 28-7415500 N555PAPyle Dana C · Naples, FLBuilt 1972 · S/N 28-7225476 N555PBM5 LLC · Kit Carson, COBuilt 1973 · S/N 287305016 N555PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842092 N555QFColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1992 · S/N 2890173 N555RUHands Holding · Newark, DEBuilt 1981 · S/N 32R-8129114 N555TBRedfish Property Enhancement LLC · Bluffton, SCS/N 32-8306013 N555TCArchibeque Christopher James · Albuquerque, NMBuilt 1977 · S/N 28R-7703061 N555TPNugget Investments LLC · Strongsville, OHBuilt 1979 · S/N 32R-8029041 N555TWMccabe Robert J Trustee · Cherry Hill, NJBuilt 1973 · S/N 28-7305578 N555UMBoretide Aviation LLC · Anchorage, AKBuilt 1971 · S/N 28-7105078 N555UWMcdaniel John D Jr · Leesburg, GABuilt 1978 · S/N 32R-7887117 N555VCBassetti Cody J · Paso Robles, CABuilt 1969 · S/N 28-26049 N555WMWest Warren K · Raymore, MOBuilt 1979 · S/N 28-7921047 N55605Parrish Don A · Plains, TXBuilt 1973 · S/N 28-7325440 N55606Falcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325441 N55608Thunderbird Aviation LLC · Shawnee, OKS/N 28-7305423 N5560FVandyke Jason M · Gettysburg, PABuilt 1968 · S/N 28-24900 N5560JSanilac Air LLC · Applegate, MIS/N 32-1025 N55610Luxury Aviation LLC · Butler, PABuilt 1973 · S/N 28R-7335258 N55613Holmquist Hugh R · Burwell, NEBuilt 1973 · S/N 28-7310151 N55617Critchett Reggie D · Sterling Heights, MIBuilt 1973 · S/N 28-7325431 N55618Keller Paul D · Burlington, CTBuilt 1973 · S/N 28-7325443 N55621Wood Steve · Fresno, CABuilt 1973 · S/N 28-7325446 N55622Detor Properties Inc · Rochester, NYBuilt 1973 · S/N 28-7305426 N55623Vector Aviation Services LLC · Groesbeck, TXBuilt 1973 · S/N 28-7305427 N55628Ag Air Squadron Two LLC · Saint Joseph, ILBuilt 1973 · S/N 28R-7335261 N55629Mccarthy Robert · Farmers Branch, TXS/N 32-7340128 N5562FTom Brian A · Santa Clarita, CABuilt 1968 · S/N 28-24902

Back to AD 87-08-08 R3