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.

N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671 N339BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881525 N339DALink Aviation LLC · Eau Claire, WIBuilt 2002 · S/N 2844077 N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097 N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012 N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067 N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287 N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136 N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182 N33EGHoug David M · Pigeon Forge, TNFirst renewal noticeS/N 28R-7803031 N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461 N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763 N33HParker Shon T · San Angelo, TXBuilt 1968 · S/N 28-11115 N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144 N33JDRiggs Alan Vance · Artesia, NMBuilt 1979 · S/N 32-7940159 N33JMKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 28-10305 N33KVWild Blue Aero LLC · O Fallon, ILBuilt 1979 · S/N 28R-7918185 N33LHKeller Charles T · Thaxton, MSBuilt 1968 · S/N 28-11098 N33PRWings To Carolina LLC · State College, PABuilt 1976 · S/N 32R-7780087 N33PSN33ps LLC · Shoemakersville, PABuilt 1978 · S/N 32R-7885277 N33PZRygiel Jerome A · Saint Cloud, FLBuilt 1975 · S/N 28-7615040 N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006 N33WBSycamore Aviation Services LLC · Terre Haute, INBuilt 1978 · S/N 32R-7987056 N33WJKite Air LLC · Staten Island, NYBuilt 1977 · S/N 32R-7780443 N33YBBriggs Kent · Manhattan, KSBuilt 1963 · S/N 28-956 N33YYMoore Keith V · Germantown, TNBuilt 1966 · S/N 28-3230 N3400WTop Flight Aircraft Holdings LLC · Dover, DEBuilt 1966 · S/N 32-261 N3402WCw Baker Investments LLC · Baton Rouge, LABuilt 1965 · S/N 32-262 N3403WSchendel Daryl R · Barstow, CABuilt 1965 · S/N 32-264 N3405MSpectrum Exploration LLC · Jacksonville, TXBuilt 1977 · S/N 28R-7803169 N3406A406a Inc · Hollywood, FLS/N 3257044 N3406WQwikflights LLC · Herriman, UTBuilt 1965 · S/N 32-267 N3407WYounkin Anthony · Ruffs Dale, PABuilt 1966 · S/N 32-299 N340BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881526 N340PAVidal Aviation LLC · Gaithersburg, MDBuilt 2002 · S/N 2843516 N3410MArborio Peter J · Wethersfield, CTBuilt 1978 · S/N 32-7940001 N3411QSillinger Daniel E · Covington, LABuilt 1977 · S/N 28-7716155 N3411WAmerican Airpower Museum · Farmingdale, NYBuilt 1965 · S/N 32-272 N3412WN3412w LLC · Lithia, FLBuilt 1965 · S/N 32-274 N3413KRogers Howard M · Douglasville, GAS/N 28-23547 N3414WIrby Almous · Enterprise, ALBuilt 1965 · S/N 32-276 N3415WSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 32-277 N3416QJaouen Dominique · Berlin, CTBuilt 1977 · S/N 28-7790457 N341DCKiener Matthew J · Pottersville, NJBuilt 1996 · S/N 3246044 N341ECPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010041 N341FTWatkins Robert W II · Parsons, TNBuilt 1982 · S/N 28-8216210 N341NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881794 N341STZimmie Thomas F · Wynantskill, NYBuilt 1973 · S/N 28-7305476 N341SW13:4 Aviation LLC · Brookfield, WIBuilt 1969 · S/N 32-40592 N341TAUnited States Of America · Travis Afb, CABuilt 2006 · S/N 2843634

Back to AD 87-08-08 R3