Skip to content

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.

N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720 N8925LLinton William A · Madison, WIBuilt 2007 · S/N T18208669 N8925NMackay James R · Corunna, MIS/N 32-40721 N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381 N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724 N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384 N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029 N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379 N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053 N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111 N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387 N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388 N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392 N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735 N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741 N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007 N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396 N8942NMinnema Samuel S · Fairbanks, AKS/N 32-40742 N8942PAncelet Grant D · Crowley, LABuilt 1966 · S/N 24-4398 N8943NChase-Six LLC · Orange Park, FLBuilt 1969 · S/N 32-40744 N8946PBreding Ralph E · American Falls, IDBuilt 1966 · S/N 24-4402 N8947NGarfield Air LLC · Burwell, NEBuilt 1970 · S/N 32-40921 N8948NC6 Flying LLC · North Logan, UTBuilt 1970 · S/N 32-40750 N894ARLayke Tool And Manufacturing Co · Meadville, PABuilt 1989 · S/N 27-0034 N894MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608576 N894SCLease Air LLC · Moab, UTBuilt 2010 · S/N GA8-TC 320-10-156 N8950NWatson Richard D · Plant City, FLS/N 32-40751 N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408 N8952NCircle K Supply Chain Solutions LLC · Knoxville, TNBuilt 1969 · S/N 32-40754 N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409 N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410 N8954CTeamco Aviation LLC · Saint Petersburg, FLS/N 32R-7680146 N8954NSabbagh Mouin F · Missouri City, TXBuilt 1969 · S/N 32-40757 N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411 N8955NRichart Nicholas J · Clever, MOBuilt 1969 · S/N 32-40758 N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412 N8957NN8957n Inc · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-40761 N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414 N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416 N895CMJlb Leasing LLC · Mequon, WIBuilt 2023 · S/N 4636826 N895PC925dt LLC · Picayune, MSBuilt 2008 · S/N T20608892 N8960NSkyriders Inc · Pocatello, IDBuilt 1969 · S/N 32-40771 N8961PRegistered aircraftBuilt 1966 · S/N 24-4418 N8962NGallen Peter · Wilmington, DEBuilt 1969 · S/N 32-40773 N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419 N8963NBaker Daniel T · Jackson, OHBuilt 1969 · S/N 32-40774 N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421 N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422 N8966NCherokee Six LLC · Minburn, IABuilt 1969 · S/N 32-40776 N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423

Back to AD 71-13-01 R1