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.

N33444Mossbarger Beverly Jo · Jamestown, OHBuilt 1975 · S/N 28-7505146 N3344QGrinch Robert J · Ridgewood, NJBuilt 1977 · S/N 28-7790452 N3344WGracey Kenneth · Burien, WABuilt 1965 · S/N 32-184 N33459A-Z Leasing LLC · Kenosha, WIBuilt 1975 · S/N 28-7515340 N33460Sportsman Airpark Inc · Newberg, ORBuilt 1975 · S/N 28-7505147 N33462Becker Barton C DBA · Oneill, NES/N 28-7505149 N3346MBromberek Gene T · Cumming, GABuilt 1977 · S/N 28R-7803136 N33480Cerva Air LLC · New Albany, INBuilt 1975 · S/N 28-7515341 N33482Poulton Robert J · Lincoln, RIBuilt 1975 · S/N 28-7505150 N33483Blue Wings Aviation LLC · Camden, SCBuilt 1975 · S/N 28-7505151 N33485Bruner Timothy R · Laurel, MDBuilt 1975 · S/N 28R-7535154 N33488Mcintyre William H · Waterloo, ALBuilt 1975 · S/N 28-7515304 N3348TWarhol Peter J · Peever, SDBuilt 1971 · S/N 28-7125330 N3348WCyrus Ely G · Kiana, AKBuilt 1965 · S/N 32-189 N33491Love Steven J · Rio, ILBuilt 1975 · S/N 28R-7535155 N33496B A T S Aviation LLC · Long Island, KSBuilt 1975 · S/N 32-7540103 N3349TStuart John R · Taylorsville, KYBuilt 1971 · S/N 28-7125463 N334ACRegistration Pending · Farmingdale, NYRegistration pendingBuilt 2005 · S/N 2842219 N334BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881084 N334CCHaspell John C · Broken Arrow, OKBuilt 1976 · S/N 28-7610122 N334CKLyders-Petersen Peter · Brighton, MIBuilt 2004 · S/N 3246222 N334GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881116 N334NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881793 N3350TBaxley Aviation LLC · Baxley, GABuilt 1971 · S/N 28-7125377 N3351WRegistered aircraftBuilt 1965 · S/N 32-193 N33520Dolbeare Eric E · Nebo, ILBuilt 1975 · S/N 28-7515295 N33529Moon Scott R · Plover, WIBuilt 1975 · S/N 28-7505154 N33530Lapointe Curtiss James · Powell, TNBuilt 1975 · S/N 28R-7535157 N33532Williams Kevin · Irvington, ALBuilt 1975 · S/N 28-7525203 N33534Two One Aviation LLC · Benton, PABuilt 1975 · S/N 28-7505155 N3353WGrigg Charles I Jr Trustee · Emporia, VABuilt 1965 · S/N 32-196 N33545Beck Brady P · Nixon, TXBuilt 1975 · S/N 28-7525206 N3354WArocho David · Orlando, FLBuilt 1965 · S/N 32-197 N33550Nutmeg Flying Club · Stratford, CTBuilt 1975 · S/N 28-7505157 N33556Midwest Diesel Inc · Beemer, NEBuilt 1975 · S/N 32-7540105 N3355WBland Joseph G · Gainesville, TXBuilt 1965 · S/N 32-198 N33560Sherron Jim Kemp IV · Raleigh, NCS/N 28-7525207 N33562Aiken Flyers LLC · Aiken, SCS/N 28-7525208 N33563Cape Fear Aviation Services LLC · Fayetteville, NCBuilt 1975 · S/N 28-7515346 N33565James Harris · Helotes, TXBuilt 1975 · S/N 28-7505158 N33566Roebke Karen L Trustee · Gilbert, AZBuilt 1975 · S/N 28R-7535161 N33567R Merritt Investments Inc · Jonesville, MIBuilt 1975 · S/N 28R-7535162 N33568Papoi Benjamin F · Phoenix, MDBuilt 1975 · S/N 32-7500025 N3356WFive Six Whiskey LLC · Plainfield, INBuilt 1965 · S/N 32-200 N33575Nationwide Aviation LLC · Hudson Oaks, TXS/N 28-7515347 N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165 N3359WMcmaster James R II · Bath, PABuilt 1965 · S/N 32-205 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085

Back to AD 87-08-08 R3