Skip to content

Registered aircraft · 5,102

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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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.

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 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 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 N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769 N896SJTumbleweed Aviation LLC · Great Bend, KSBuilt 1996 · S/N 46-36033 N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427 N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429 N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430 N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435 N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862 N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439 N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441

Back to AD 81-12-06 R1