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.

N265FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020261 N265MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881363 N265NDAri Ben Aviator Inc · Fort Pierce, FLS/N 2842065 N265TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020132 N2660QSummit Aviation LLC · Spokane, WABuilt 1977 · S/N 28-7790413 N2661TSix One Tango LLC · Pismo Beach, CABuilt 1971 · S/N 28-7205069 N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070 N2666TNess Ronald O · Canyon Lake, CABuilt 1971 · S/N 28-7210002 N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092 N2669TCity Of Westfield · Westfield, MAS/N 28-7225082 N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760 N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262 N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364 N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040 N2672THilgendorf Blake W · Fairmont, MNBuilt 1971 · S/N 28-7110027 N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11 N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075 N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084 N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074 N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077 N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078 N2679QMorgan Jonathan P · Mooresville, NCBuilt 1977 · S/N 32R-7780260 N267AGSimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 28-7425114 N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141 N267DPCarrasco Mario G · Glendora, CABuilt 1967 · S/N 28-22673 N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365 N267NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842067 N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261 N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261 N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261 N2680TAviyon Aviation LLC · Orlando, FLBuilt 1971 · S/N 28-7225085 N2681TFetty Eric · Burleson, TXBuilt 1971 · S/N 28-7210003 N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086 N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082 N2684TGallaher Matthew · Anchorage, AKBuilt 1971 · S/N 28-7225087 N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083 N2687THolley Ronald E · Hastings, MIBuilt 1971 · S/N 28-7205093 N2688BScott Fred · Greencastle, INBuilt 1968 · S/N 28-5065 N26893Goodman Harold Wayne · Clovis, CAS/N 28R-30679 N268BGHuff Holdings LLC · Ashland, KYBuilt 1976 · S/N 28-7690268 N268DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010068 N268MAMasters Of The Air LLC · Salt Lake City, UTBuilt 1975 · S/N 28-7515338 N268MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881366 N2691TSilkgate Aviation LLC · Yorba Linda, CABuilt 1971 · S/N 28-7205065 N2692TWingsleasing LLC · Wichita, KSBuilt 1971 · S/N 28-7205072 N2694GInspec Aviation Inc · Schwenksville, PABuilt 1980 · S/N 28-8090230 N2694TStubby Wings LLC · Eden Prairie, MNBuilt 1971 · S/N 28-7205085 N2695TJean-Baptiste Joseph C Sr · Brockton, MABuilt 1971 · S/N 28-7225089 N2696RBowen Diane M · Newbury, MABuilt 1969 · S/N 28R-35248 N2696TRsp Aero LLC · Griffin, GABuilt 1971 · S/N 28-7205087

Back to AD 87-08-08 R3