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.

N5982UCapital Aviation LLC · Fuquay Varina, NCBuilt 1970 · S/N 28-26757 N5982WHarris Chad A · Hamilton, ALBuilt 1967 · S/N 28-4342 N5983USale Reported · Adelanto, CASale reportedBuilt 1970 · S/N 28-26825 N5983VOdonnell Richard J III · Crab Orchard, WVS/N 28R-7703175 N5983WAnderson Kerri · Frazier Park, CABuilt 1968 · S/N 28-24783 N5984UDenton Richard A · Plant City, FLBuilt 1970 · S/N 28-26871 N5984WN4036r LLC · Quinton, ALBuilt 1968 · S/N 28-24784 N5985WSterling West Corp · Camden, DENon-citizen corporation, flight hours not reportedBuilt 1969 · S/N 28-25765 N5986UHolt Drew R · Lake Jackson, TXS/N 28-26872 N5986VLampin Aviation LLC · Brielle, NJBuilt 1977 · S/N 32-7700018 N5986WActon David D · Thousand Oaks, CABuilt 1968 · S/N 28-24788 N5987UBergquist Carol F · Saint Paul, MNBuilt 1970 · S/N 28-26805 N5987WWilson Brandon · Bozeman, MTS/N 28-24790 N5988UPayan Oscar A · Teaneck, NJS/N 28-26873 N5988WWest Central Aviation LLC · Prinsburg, MNS/N 28-24791 N5989WSmith Kevin L · Peachtree City, GABuilt 1968 · S/N 28-24792 N598APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843767 N598MAMartini Richard · North Haven, CTBuilt 1997 · S/N 3257009 N598PWings 4 Higher LLC · Sunnyside, WABuilt 1970 · S/N 28R-35763 N598SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881411 N5991UDiggle Kenneth A · Coventry, RIBuilt 1970 · S/N 28-26788 N5991VDebry Michael W Trustee · Palmdale, CABuilt 1977 · S/N 32R-7780386 N5991WChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 28-24795 N5993FGarrett L Gale · Valentine, NES/N 28-7790149 N5993UNakashima Stephen · Dayton, OHBuilt 1970 · S/N 28-26576 N5993WSwinford Aaron R · Wynnewood, OKBuilt 1968 · S/N 28-24798 N5994WHurst Billy W · Lonoke, ARS/N 28-24799 N5995USharp Aircraft LLC · Mcminnville, TNBuilt 1970 · S/N 28-26813 N5995WLarson Monty · Mott, NDBuilt 1968 · S/N 28-24800 N5997VAero Association Of Caltech Inc · Pasadena, CAS/N 28-7790515 N5997WWedgewood Ventures LLC · Missoula, MTS/N 28-24812 N5998VIsland Flyers Inc · Addison, TXBuilt 1977 · S/N 28-7725264 N59ARPiper Aircraft Inc · Vero Beach, FLS/N 28010100 N59BBCooper Richard B · Fort Worth, TXBuilt 1981 · S/N 32-8124034 N59CGStoicovici Mircea · Toccoa, GABuilt 1966 · S/N 28-21606 N59EAHorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26173 N59GRTkaczyk Gary J · Canton, MIBuilt 1981 · S/N 32-8106093 N59LMHunter Brian D · Scranton, IABuilt 1977 · S/N 28R-7703402 N59SWLg Services LLC · Chino, CABuilt 1966 · S/N 32-753 N59TXThacker Jackie W · Hineston, LABuilt 1978 · S/N 32R-7887105 N5AASimanski Charles J · Onley, VABuilt 1973 · S/N 28-7325670 N5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-7725239 N5BMDja Enterprises LLC · Los Angeles, CABuilt 1979 · S/N 28-8090181 N5DPN5dp LLC · Ann Arbor, MIBuilt 1973 · S/N 28-7405033 N5DWSanderson Luann E Trustee · Lawrence, KSS/N 28R-8331027 N5JNOcchiuzzo Joseph A · Holyoke, MAFirst renewal noticeBuilt 1963 · S/N 28-1528 N5LGStuller Dennis · Fort Denaud, FLBuilt 1966 · S/N 28-22238 N5MHGould Ralph Harvey Jr · White Cloud, MIBuilt 1967 · S/N 32-40268 N5PSC H C Services Inc · Bossier City, LABuilt 1977 · S/N 32R-7780188 N5SWPrendergast Gene D · Willcox, AZBuilt 1978 · S/N 32R-7887150

Back to AD 87-08-08 R3