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.

N4116KRed Cloud One LLC · Cornwall, NYBuilt 1984 · S/N 31-8312019 N4117ZC And R Hospitality LLC · Burkeville, TXBuilt 1984 · S/N 31-8452015 N41189Yr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 31-8553002 N4118B4118b Leasing LLC · Hallandale Beach, FLBuilt 1984 · S/N 31-8452021 N4118GYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 31-8453001 N4118RHampsch Jeremy · Hauser, IDBuilt 1968 · S/N 32-40437 N4118WWisniewski Travis J · Porter, TXBuilt 1967 · S/N 32-40181 N4119KLe Doux Aviation LLC · Hollis, NHBuilt 1997 · S/N 3257020 N4119RMott Patrick T · Ballston Spa, NYBuilt 1967 · S/N 32-40188 N411CFGuynn James H · Arlington, VABuilt 1968 · S/N 31-339 N411CVTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N T20609251 N411DRParkway Investments LLC · Rexburg, IDBuilt 2007 · S/N T18208713 N411FMGo By Truck Inc · Denton, TXBuilt 1998 · S/N 27-0246 N411FSRomain Bevin G · St Thomas, VIBuilt 1962 · S/N 1162-85 N411KWEscondido Aviation LLC · Marfa, TXBuilt 2011 · S/N T20609034 N411MDJdr Inc · Cullman, ALBuilt 2000 · S/N 4636262 N41208Scott Kevin L · Kissimmee, FLBuilt 1974 · S/N 32-7440076 N4120SBukstein Michael J · Hannibal, MOBuilt 1998 · S/N 3257045 N4120WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N 32-40184 N41210Fisher Jordan L · Bennington, NEBuilt 1974 · S/N 32-7440061 N4121KMalibu Air LLC · Wilmington, DEBuilt 1998 · S/N 4636140 N4122RLowenslow LLC · Hailey, IDBuilt 1997 · S/N 3257010 N4122WGo West Aviation LLC · Gillette, WYBuilt 1967 · S/N 32-40186 N4123WSchaal Donald P · Wauconda, ILS/N 32-40187 N4127KRegistered aircraftBuilt 1998 · S/N 3257035 N4127RStar Marianas Air Inc · Saipan, MPBuilt 1968 · S/N 32-40445 N4127WSkipgen Holdings LLC · Miami, FLBuilt 1967 · S/N 32-40192 N4128RRose Brandon R · Lockhart, TXS/N 32-40446 N4129QToga Aviation LLC · Republic, MOBuilt 1999 · S/N 3257090 N4129WH & L Air LLC · Charlotte, MIS/N 32-40195 N412BDWatts Keith · Lodi, CABuilt 2009 · S/N 4692115 N412BWGms Storage Solutions LLC · Lake Oswego, ORBuilt 2005 · S/N T18208476 N412TMFlying J Aviation LLC · Sargent, NES/N 31-510 N4130RMaverick Hunter Airlines LLC · Stuart, FLBuilt 1968 · S/N 32-40448 N4131LRegistration Pending · Norwalk, CTRegistration pendingBuilt 1998 · S/N 3257068 N4131WRudd Joshua A · Cresson, TXBuilt 1967 · S/N 32-40197 N41322Jackson Ben · Wrightsville, GABuilt 1999 · S/N 3257078 N4132WTopken William F · Fallon, NVBuilt 1967 · S/N 32-40198 N41335Doherty Gordon W Jr · Garden Plain, KSBuilt 1974 · S/N 32-7440083 N4133GAmsg Transport LLC · Bloomfield Hills, MIBuilt 1998 · S/N 4636186 N4133RFlying Friends LLC · Lynchburg, VABuilt 1968 · S/N 32-40450 N4133WHochstedler Wilford L · Parsons, KSBuilt 1967 · S/N 32-40199 N4134BWildrose Aviation LLC · Victor, CABuilt 1974 · S/N 74-31102 N4134DScull Timber Co Inc · Tenaha, TXBuilt 1998 · S/N 3257070 N4135QRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1977 · S/N 32R-7780329 N4135RHinkle Robert J · Caldwell, IDBuilt 1968 · S/N 32-40452 N41365Henke Cory William · Rosendale, WIBuilt 1974 · S/N 32-7440086 N4136FBeising Steven E · Las Vegas, NVBuilt 1976 · S/N 32R-7680429 N4136RRobinson Douglas A · Derry, NHBuilt 1968 · S/N 32-40492 N4136SCrass David B · Aledo, TXBuilt 1999 · S/N 3257093

Back to AD 71-13-01 R1