Registered aircraft · 22,411

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.

N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956 N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268 N199HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 3246126 N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100 N199MWWoftam Inc Trustee · Wilmington, DEBuilt 1979 · S/N 327940219 N199PGArnett Joshua · Lucas, TXBuilt 1982 · S/N 28R-8218020 N199PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-35694 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N199TPBlue Line Aviation LLC · Dunbar, NEBuilt 1972 · S/N 28-7325193 N199WBReinert Joseph Mason DBA · Chattanooga, TNBuilt 1963 · S/N 28-1040 N19AVGhafouri Mohsen · Murrieta, CABuilt 1981 · S/N 28-8216106 N19GJJmd Aviation LLC · Guilford, CTBuilt 1973 · S/N 28-7405020 N19HJLogan Lonnie L · Grand Island, NEBuilt 1973 · S/N 32-7300020 N19PAAkradi Parviz Trustee · Laguna Niguel, CABuilt 1977 · S/N 28R-7803129 N19PEN19pe LLC · Stone Mountain, GABuilt 1978 · S/N 32R-7885068 N19SERegistered aircraftBuilt 1968 · S/N 28R-30525 N19VTBeauchamp James W · Corapeake, NCBuilt 1962 · S/N 28-400 N1LPRegistration Pending · Lynn Haven, FLRegistration pendingBuilt 1965 · S/N 28-2666 N1MPFly One Mp LLC · Omaha, NEBuilt 1972 · S/N 28-7305143 N1QABender Edward C Jr · Lansdale, PABuilt 1973 · S/N 28R-7335303 N1UGRegistered aircraftS/N 32R-7780308 N1UKPenn Flight School LLC · Quakertown, PABuilt 1977 · S/N 28-7790564 N2003MRoyal Timothy G · Apex, NCBuilt 1977 · S/N 28-7890221 N2007MCritz Sue A · El Paso, TXBuilt 1977 · S/N 28R-7837061 N200ACKerstetter Michael S · Hewitt, NJBuilt 1969 · S/N 28R-35656 N200ADNouvel Avion LLC · Miami Gardens, FLBuilt 1976 · S/N 28-7690230 N200CARosenberg Frank D · Tempe, AZBuilt 1979 · S/N 327940205 N200CF200cf LLC · Decatur, ILS/N 32-7700005 N200DWLillian Aviation LLC · Cypress, TXBuilt 2003 · S/N 2844102 N200EFLame Deer LLC · Flemington, NJBuilt 1977 · S/N 28R-7703168 N200FKJmm Air LLC · Put In Bay, OHBuilt 2007 · S/N 3232072 N200GKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7335287 N200HMBill Keck Aviation LLC · Marlow, OKBuilt 1975 · S/N 32R-7680025 N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255 N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176 N200MABas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887266 N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431 N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321 N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182 N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210 N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200VMBaker Creek Enterprise · Townsend, GABuilt 1976 · S/N 32R-7780073 N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363 N200YRSloan Cooper · Seattle, WAS/N 28-7615279 N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409 N2018MSanders Drew C · Cortez, COBuilt 1977 · S/N 28R-7803100 N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630 N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429 N2023RWhitehurst Brian P Trustee · Crossville, TNBuilt 1969 · S/N 28-5430

Back to AD 87-08-08 R3