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.

N4051WHenningsen Gregory Mark · Arvada, COBuilt 1966 · S/N 32-40071 N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002 N4053RDorsett Brandon · Buckeye, AZBuilt 1967 · S/N 32-40355 N4055RBroadhurst Eric Clark · Brookline, NHBuilt 1967 · S/N 32-40358 N4055WDiehl Frances M · Alamogordo, NMBuilt 1966 · S/N 32-40079 N4056WHighwing Flyers Inc · Cape May Ch, NJBuilt 1966 · S/N 32-40081 N4057RCurrier Dustan · Fairbanks, AKBuilt 1967 · S/N 32-40361 N4057W57whiskey LLC · Rowlett, TXBuilt 1966 · S/N 32-40083 N4058QPerry John S Jr · Hudson, WIS/N 28-7790469 N4058RSanders Christopher A · Escondido, CABuilt 1967 · S/N 32-40363 N4058WBrandon Sidney J III · Dundas, VABuilt 1966 · S/N 32-40085 N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738 N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263 N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110 N405DSDelaware State University · Dover, DEBuilt 1976 · S/N 28-7715243 N405FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125181 N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113 N405SGriffing Flying Service Inc · Port Clinton, OHBuilt 1986 · S/N 2890015 N405SBSky Bright Inc · Gilford, NHBuilt 1978 · S/N 28-7916139 N405WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640043 N4060FJones Brent M · Las Vegas, NVS/N 28-7790003 N4061RHorse Saddle Shop Inc · Bremen, INBuilt 1967 · S/N 32-40369 N4064RHissem John T · Castle Rock, COBuilt 1967 · S/N 32-40372 N4065529 Uniform LLC · Nashville, TNBuilt 1977 · S/N 28-7890005 N4065QZajdel Edwin J Jr · Ocean City, MDBuilt 1977 · S/N 28R-7737060 N4065RDever Brandon · Auburn, CABuilt 1967 · S/N 32-40373 N4065WGrubs Jon P · Winter Haven, FLBuilt 1967 · S/N 32-40099 N4066QDmb Aviation LLC · Oakland, MIS/N 28R-7703120 N4066RMoore Arthur Douglas · Sulphur Springs, TXBuilt 1967 · S/N 32-40374 N40670Cavorite Aviation LLC · Lehi, UTBuilt 1977 · S/N 28-7890007 N40679Skipper Consulting LLC · Athens, ALBuilt 1977 · S/N 28R-7737132 N4067RM & H Aviation LLC · Homestead, FLBuilt 1967 · S/N 32-40375 N4067WBluestone Land LLC · Charlottesville, VABuilt 1966 · S/N 32-40103 N4068QAerotechnics Aviation Inc · GloucestershireBuilt 1977 · S/N 28R-7703121 N40697Freiberg Industries Inc · State Center, IABuilt 1973 · S/N 28R-7435113 N40698Murphy Robert H · Skagway, AKBuilt 1973 · S/N 32-7440056 N4069WRoss Christian M · Bakersfield, CABuilt 1966 · S/N 32-40107 N406AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843739 N406AFN406af LLC · Fort Pierce, FLBuilt 1966 · S/N 28-21837 N406DRKent Keith M · Ellijay, GABuilt 1978 · S/N 28-7916072 N406DSDelaware State University · Dover, DEBuilt 1974 · S/N 28-7415419 N406FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020206 N406MACti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 2881123 N406PGShumacker James N · Carmel, INBuilt 2021 · S/N 2881449 N406RBAirflair Inc · Maurice, IABuilt 1977 · S/N 32R-7880009 N406SLRhett Howard · Amherst, MABuilt 1974 · S/N 28R-7435293 N406WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640058 N40704Dikun Paul M · Bensalem, PABuilt 1973 · S/N 28-7425147 N4070RBamfs Group LLC · Davie, FLBuilt 1967 · S/N 32-40380 N40718Datchair LLC · Chattanooga, TNBuilt 1973 · S/N 28-7425150

Back to AD 87-08-08 R3