Registered aircraft · 4,001

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:81-13-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1') 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:81-13-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
  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:81-13-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
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.

N28KLWright Thomas R · Arlington, WABuilt 2010 · S/N 70025 N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253 N28SCDouville Kenneth · Derry, NHBuilt 2001 · S/N 1137 N28SWShiftta LLC · Ramrod Key, FLBuilt 1979 · S/N 28R-7931308 N29027Cb Aerosports Inc · Charlotte, NCS/N 28R-7931188 N290CDMenezes Marcelo Vianna · Hampstead, NCBuilt 2002 · S/N 1167 N290XDickson Bernard G · Chiloquin, ORBuilt 1975 · S/N 6114C N291Northern Sky LLC · Dover, DEBuilt 1976 · S/N P3370234 N2911WAdduci Alexander Lewis · Trevor, WIBuilt 1979 · S/N 28R-7931253 N2915TSierra Canyon Enterprises · Big Bear City, CABuilt 1979 · S/N 28-7921041 N291XMccown Bobby E · Soldotna, AKFirst renewal noticeBuilt 1975 · S/N 6117C N2922ULowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1979 · S/N 34-7970377 N29247Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 28R-7931195 N29257Blackwell Aviation LLC · Tacoma, WABuilt 1979 · S/N 34-7970244 N2925VCortese Thomas J · Sedona, AZBuilt 1977 · S/N R1722234 N292LKAerial Options LLC · Powell, OHBuilt 2002 · S/N 1254 N292XStairs Richard B · Fountain, FLBuilt 1975 · S/N 6120C N293Zer Holdings LLC · Woodinville, WABuilt 1975 · S/N P3370226 N2931LPlanesmen LLC · Liberal, KSS/N 34-7970387 N2931MNsain Flight Ops LLC · Fort Worth, TXBuilt 1977 · S/N 28R-7803154 N2933QThomas Mark E · Corpus Christi, TXBuilt 1977 · S/N 34-7770200 N2937BHaas Terry D · New Tripoli, PABuilt 1979 · S/N 28R-7931261 N29394Davis Kenneth Howard · Waxahachie, TXBuilt 1979 · S/N 28-7921033 N2939NPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 28R-7931263 N293CDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 1202 N293XEvans Kent L · Mason City, NEBuilt 1975 · S/N 6122C N29408Angels Aviation LLC · Ripon, CABuilt 1979 · S/N 28-7921035 N29435Cazares James · Barrington, ILBuilt 1979 · S/N 34-7970247 N2943YMatana Aviation Group LLC · Bradenton, FLBuilt 1979 · S/N 28R-7931267 N29466Lake Area Technical College · Watertown, SDBuilt 1979 · S/N 34-7970257 N2949EReve Air Inc · La Place, LABuilt 1979 · S/N 34-7970397 N2949VKingdom Power And Glory LLC · Colorado Springs, COBuilt 1977 · S/N R1722235 N2953QW-Wingmen LLC · Simi Valley, CABuilt 1977 · S/N 28R-7703084 N295BPQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 347570249 N295CDSale Reported · ZlinSale reportedS/N 1206 N295RNew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133185 N2965RSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 34-7970425 N2969ZJwest Aero LLC · Smyrna, DEBuilt 1979 · S/N 28R-7931281 N296BWAmerican Driveaway LLC · Cowden, ILBuilt 1977 · S/N R1722379 N296EGGrell Georg A · Golden, COBuilt 2015 · S/N G01 N296XHerrema Scott A · White Cloud, MIBuilt 1975 · S/N 6126C N297Halsted Barry J Trustee · Sequim, WABuilt 1990 · S/N 001 N2970LCgi Transport Inc · Fullerton, CABuilt 1979 · S/N 28R-7931284 N297CDDutton James Alen · Double Oak, TXBuilt 2002 · S/N 1232 N297DCPriority Farms · Glenn, CAS/N 33701697 N297TPCates Julia · Florence, SCS/N 1134 N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158 N298CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1175 N298PJAxelrod Timothy S Trustee · Bandon, ORBuilt 2006 · S/N 71609 N299CDLinmac LLC · Miami, FLBuilt 2002 · S/N 1267

Back to AD 81-13-10 R1