Skip to content

Registered aircraft · 657

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-25-08-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-25-08-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-25-08-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-25-08-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-25-08-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-25-08-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.

N62JCChuoke Joseph P · Texas City, TXS/N 421C0498 N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406 N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003 N633MCSveen Jeffrey T · Aberdeen, SDBuilt 1979 · S/N 421C0657 N645SBN645 Shares LLC · Liberal, KSBuilt 1984 · S/N 425-0217 N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648 N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474 N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275 N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408 N6633TC C I C Aircraft Division One LLC · Kalispell, MTBuilt 1977 · S/N 421C-0277 N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467 N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019 N6772PRomeo Golf LLC · Wernersville, PABuilt 1981 · S/N 425-0022 N6796VBar Wr Air Services LLC · Dallas, TXS/N 421C1045 N6798VGaylord Hangars LLC · Gaylord, MIBuilt 1982 · S/N 421C1254 N6798XSale Reported · WurzburgSale reported, pending cancellationS/N 421C1061 N679JJClement James H Jr · Dallas, TXS/N 421C0637 N67BAFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0007 N67JVNext Gen Aviation LLC · Jenks, OKBuilt 1978 · S/N 421C0429 N6824CK&L Salty Air LLC · Stephenville, TXBuilt 1980 · S/N 421C0865 N6834CHigh Performance Aero LLC · Dover, DEBuilt 1978 · S/N 421C0476 N6844DShort Field LLC · Bellevue, WABuilt 1981 · S/N 425-0062 N6846SN414v LLC · Farmington, MNBuilt 1981 · S/N 425-0081 N6858CSns Air LLC · Billings, MTBuilt 1978 · S/N 421C0481 N685GFAvant Homes LLC · Atlanta, GAS/N 421C0680 N6865ZBarriault Ronald F · Greenville, MES/N 421C1068 N6866LPoquoy Brook Aviation LLC · North Attleboro, MAS/N 421C1077 N6867F81 Cessna 421 LLC · Ladson, SCS/N 421C1086 N6867LRubin Broadcasting Inc · San Jose, CAS/N 421C1087 N6867ZSonic Bird 1 LLC · Hagerstown, MDBuilt 1981 · S/N 421C1090 N68685S&S Airplane LLC · Knoxville, TNS/N 421C1102 N6869Z421 Holdings LLC · Zanesville, OHS/N 421C1111 N6882MScuttle421 LLC · Sugar Land, TXS/N 421C1074 N6885SErnst Law Group · San Luis Obispo, CABuilt 1981 · S/N 425-0144 N698DRAtm Asset Management LLC · Nashville, TNS/N 421C0235 N700FBBocre Leasing Inc · Hauppauge, NYBuilt 1977 · S/N 421C0342 N700LCRent Collector LLC · College Station, TXS/N 421C0836 N700WJFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0036 N706AAArcher Automotive Inc · Houston, TXBuilt 1981 · S/N 421C1075 N706LBRf Logistics Inc · Santa Teresa, NMBuilt 1981 · S/N 4250033 N706NCGaylord Hangers LLC · Gaylord, MIBuilt 1975 · S/N 421C0037 N707CBHarkal Enterprises Ltd · Des Moines, IABuilt 1980 · S/N 425-0023 N707HATailwinds Aero LLC · Dubuque, IAS/N 421C1044 N707TPRicker David · Conway, ARS/N 421C0271 N711KZPlp Casino Game Development LLC · Leesburg, FLBuilt 1976 · S/N 421C0023 N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908 N7135GRegistered aircraftBuilt 1977 · S/N 421C0284 N717LRJnnss LLC · Hillsborough, NJS/N 421C1109 N71HEBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0085 N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066

Back to AD 91-25-08 R1