Skip to content

Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

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 N8960YSmith Jeremiah R · Fort Wayne, INBuilt 1978 · S/N 32R7887047 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 N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867 N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443 N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147 N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445 N8986NBay Air Inc · Dillingham, AKS/N 32-40869 N8986PNielsen James R · Carson City, NVS/N 24-4446 N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148 N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871 N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031 N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358 N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451

Back to AD 91-21-01 R1