Registered aircraft · 54,015

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.

N73179Weengknutts 179 · Delta, UTS/N 17267306 N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017 N7317SGoodman Jack A · Memphis, TNBuilt 1976 · S/N 18265109 N7317XMoore Samuel B · Tucson, AZS/N R18200073 N73181Nurse Alex S · San Diego, CABuilt 1976 · S/N 17267308 N73182Savannah Airplanes Venture LLC · Myrtle Beach, SCBuilt 1973 · S/N 18261434 N73183Sandwich Aviation Inc · Somonauk, ILBuilt 1976 · S/N 17267310 N73189Ellie Air LLC · Mabank, TXBuilt 1976 · S/N 17267316 N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018 N7318HMichaud Francis G · Marine St Crx, MNBuilt 1977 · S/N 18503359 N7318MOttis David J · Norfolk, NES/N 55618 N7318SStahl K Joseph · Gainesville, TXBuilt 1976 · S/N 18265110 N73190Flying J Enterprises LLC · San Antonio, TXBuilt 1976 · S/N 17267317 N73192Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267319 N73195Saratoga Flyers Inc · South Glens Falls, NYBuilt 1976 · S/N 17267322 N73197Seward Kent · Parma, IDBuilt 1976 · S/N 17267324 N73198Davis Jimmy R Jr · Wharton, TXBuilt 1976 · S/N 17267325 N73199Performance Polymer Technologies LLC · Roscommon, MIBuilt 1976 · S/N 17267326 N7319AHart George · Yuba City, CAS/N A1500712 N7319DN7319d LLC · Port Saint Lucie, FLBuilt 1979 · S/N 17272913 N7319GPiguzov Yevgeniy · Hillsborough, NJBuilt 1970 · S/N 17259019 N7319MCordes Hannah K · Winthrop, WABuilt 1958 · S/N 55619 N7319QBassett Robert C · Gypsum, COBuilt 1972 · S/N 18260959 N7319TAlberta Aviation LLC · Wyoming, MIBuilt 1977 · S/N R18200028 N7319XHays Software Development LLC · Timnath, COBuilt 1977 · S/N R18200075 N731AALandis Lloyd B · Ardmore, OKBuilt 1970 · S/N 182-60331 N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735T N731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763T N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437 N731BMBenaiah Holdings Corp · Marion, KYS/N 18802768T N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545 N731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785T N731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794T N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442 N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446 N731ECFitchett Bradley S DBA · Ellsworth, KSS/N 18802830 N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843T N731ESSky Tech Inc · Dorchester, NES/N 18802845T N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450 N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452 N731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862T N731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864T N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454 N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457 N731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877T N731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887T N731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891T N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464 N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465 N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468

Back to AD 87-20-03 R2