Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N3371FRavens Rebuilders Inc · Ellenboro, WVS/N 18257371 N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N3371YChavers Finley L · Newnan, GABuilt 1962 · S/N 18254371 N3372DWings Like Eagles Aviation LLC · Newnan, GABuilt 1955 · S/N 32170 N3372FSwanner Robert Craig II · Water Valley, MSBuilt 1966 · S/N 18257372 N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172 N3372ULeading Edge Operations LLC · Knoxville, TNBuilt 1963 · S/N 18254772 N3372VSimmons Robert J · Rising Fawn, GABuilt 1974 · S/N 15076478 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N3373DCarpenter Marshall Owen · Isanti, MNBuilt 1956 · S/N 32171 N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325 N3373RSkylane N3373r LLC · Rancho Cucamonga, CABuilt 1967 · S/N 18258673 N3373SWestern Metal Products LLC · Ellensburg, WABuilt 1964 · S/N 18255390 N3373URms Industrial Sales LLC · Neenah, WIBuilt 1963 · S/N 18254773 N33748Mcgowan Daniel J · Springville, CAS/N 18052525 N3374DScootair LLC · Alburgh, VTBuilt 1955 · S/N 32172 N3374LLewallen William J · Eloy, AZBuilt 1967 · S/N 185-1326 N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374UMurphy & Son Construction Inc · Brownsville, VTBuilt 1963 · S/N 18254774 N3374YRegistered aircraftBuilt 1962 · S/N 18254374 N3375DQualls Randy J · Claremore, OKBuilt 1955 · S/N 32173 N3375FKintner William R · Port Angeles, WABuilt 1966 · S/N 18257375 N3375LRowan William · New Fairfield, CTBuilt 1967 · S/N 185-1327 N3375RRoyellair LLC · Stone Mountain, GABuilt 1967 · S/N 18258675 N3375SN1811 LLC · Aurora, ORS/N 18502283 N3376DHammond James F · Yellow Springs, OHBuilt 1955 · S/N 32174 N3376EFresh Air LLC · Camarillo, CABuilt 1982 · S/N 18268243 N3376RStumm Robert W · Cadott, WIBuilt 1967 · S/N 18258676 N3376VHill Craig · Memphis, TNBuilt 1974 · S/N 15076481 N3376YFly Greater Breezewood LLC · Clearville, PABuilt 1962 · S/N 18254376 N3377JGriffith Scott · Hewitt, TXBuilt 1967 · S/N 15066077 N3377RLonestar Aeronautics LLC · Paige, TXBuilt 1967 · S/N 18258677 N3377VGardner Terrence L · Pittsboro, NCS/N 15076482 N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277 N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524 N3378SM Mercer Livestock Transportation LLC · Hyattville, WYS/N 18502285 N3378UJeppson Edward M · Nephi, UTBuilt 1963 · S/N 18254778 N3379UJames Mccullough · Hempstead, TXBuilt 1963 · S/N 18254779 N337AFKinetic Concepts LLC · Pensacola, FLBuilt 1967 · S/N 67-21344 N337BMorris Robert D · Laughlin, NVBuilt 1967 · S/N 337-0775 N337BBLewis University · Romeoville, ILBuilt 1969 · S/N 33701194 N337BDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 0062 N337BNDestiny Center Inc · Murfreesboro, TNBuilt 1972 · S/N 33701449 N337BTKrall Jeff · Mitchell, SDBuilt 1969 · S/N 33701223 N337CBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0905 N337CACendejas Christian · Montclair, CABuilt 1979 · S/N 17272213 N337CDKeller Stephen P · Wichita, KSBuilt 1973 · S/N 33701495 N337CEBeam David M · Sabina, OHBuilt 1976 · S/N 33701762

Back to AD 87-20-03 R2