Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N5193MTar Pit Investments LLC · Austin, TXBuilt 2002 · S/N T18208146 N5195UChi Aerospace Inc · Portsmouth, NHS/N T18208941 N51964Shorebird LLC · West Chester, PABuilt 2009 · S/N T20608936 N5196KMiller Andrew Howard · Granbury, TXBuilt 2009 · S/N T18208944 N5197GDirect-To LLC · Cedar Park, TXS/N T20608940 N5198GConaway David L · Las Vegas, NVBuilt 2002 · S/N T18208150 N519CASakitumi LLC · Wilmington, DES/N 14239 N519DMSingh Aviation LLC · San Antonio, TXBuilt 2012 · S/N 4636528 N519MBThomas Andrea · Sacramento, CAS/N 27-0200 N519WATropeano Construction Inc · Belleview, FLBuilt 1970 · S/N 3081 N519WRTsmhta LLC · Indianapolis, INBuilt 2000 · S/N 4636259 N51BKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 4636566 N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516 N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412 N51KMBaker Leasing LLC · Kotzebue, AKBuilt 1973 · S/N 31-7305009 N51PGFly N' Fish LLC · Jacksonville, FLBuilt 1984 · S/N 32R-8529003 N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885 N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886 N5205SAgrivation LLC · Indianola, IABuilt 1969 · S/N 32-40894 N5205UVoloshin Vitaly Alexandrovich · Seattle, WABuilt 2002 · S/N T18208153 N5207SOhio Air Enterprises LLC · Lancaster, OHBuilt 1969 · S/N 32-40898 N5208S5fs Aviation LLC · Lewes, DEBuilt 2002 · S/N 18281138 N5209FMidwest Avtech Inc · South Barrington, ILBuilt 2002 · S/N T18208155 N5209POliver Dennis L · Williamsburg, IABuilt 2002 · S/N T18208156 N5211VPipe Dream LLC · Stout, OHBuilt 2002 · S/N T20608379 N5212SHastings Reginald J · Brookshire, TXBuilt 1970 · S/N 32S-40904 N5215SFive Generation Flyers LLC · Melbourne, FLBuilt 1970 · S/N 32-40909 N5219EUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608383 N521ASStanz John Trustee · Maple City, MIBuilt 1982 · S/N 32R-8229051 N521AWUrban Equipment LLC · Vineland, NJBuilt 1971 · S/N 31-765 N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067 N521MGHlma LLC · Waverly, WVBuilt 2015 · S/N 4636663 N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149 N5221S3a LLC · Trussville, ALS/N 32-40915 N5222GHanger C16 LLC · Pinckney, MIBuilt 2002 · S/N T18208164 N5223SFrancis Larry Wayne · Whitewright, TXBuilt 2003 · S/N T20608384 N5225YGarret G Enterprises LLC DBA · Lakewood, COBuilt 2002 · S/N T18208165 N5226KHailey Medical Staffing LLC · Hailey, IDBuilt 2008 · S/N T20608904 N5226QNitsche Robert Kevin · Giddings, TXBuilt 2009 · S/N T20608917 N52278Fox Kevin Richard · Murrieta, CABuilt 2009 · S/N T20608908 N52285Calcasieu Parish Sheriffs Office · Lake Charles, LABuilt 2009 · S/N T20608915 N5229CInertia Engineering & Machine Works Inc · Stockton, CABuilt 2010 · S/N T20608980 N5229SInk International Inc · Lawrenceville, GABuilt 1970 · S/N 32-40933 N522BSSnapdog Services Inc · Wilmington, DEBuilt 2007 · S/N T20608733 N522CAC-140 Company LLC · Milton, FLBuilt 1971 · S/N 27-4711 N522MCRegistered aircraftBuilt 2021 · S/N T20609668 N522PMRegistration Pending · Castle Rock, CORegistration pendingS/N 4636568 N522RARaven Aircraft LLC · Prescott, AZS/N T18208689 N5230DColeman Mark W · Longview, TXS/N T20608922 N5231CAir Cooled Flyers LLC · Austin, TXBuilt 2009 · S/N T20608927

Back to AD 71-13-01 R1