Skip to content

Registered aircraft · 58

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:2004-22-28') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-22-28') 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:2004-22-28')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-22-28')
  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:2004-22-28')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-22-28')
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.

N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N101SNGorsuch Aviation LLC · Lancaster, OHBuilt 1981 · S/N BE-118 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N10AGBaron Associates LLC · Norfolk, VABuilt 1980 · S/N BE-100 N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116 N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111 N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119 N236CPArtic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-9 N248JHExecutive King Air Transportation Inc · Wilmington, DEBuilt 1982 · S/N BE-126 N24EMAsphalt Aviation LLC · Conway, SCBuilt 1976 · S/N BE-6 N264PARisk Assumption LLC · Horseshoe Bay, TXBuilt 1980 · S/N BE-86 N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24 N301TSNeptune Aviation Services Inc · Missoula, MTBuilt 1979 · S/N BE-76 N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113 N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99 N343KKTreeline Transportation Inc · Vance, ALBuilt 1978 · S/N BE-46 N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62 N3532North Delta Ag Aviation LLC · Sledge, MSBuilt 1977 · S/N BE-31 N3536Vantage Aviation USA LLC · Tampa, FLBuilt 1979 · S/N BE72 N3538New Mountain Aviation LLC · Englewood, COBuilt 1978 · S/N BE-57 N3539Thacker Aircraft Holding LLC · Lubbock, TXBuilt 1982 · S/N BE-124 N360BLBachman Aviation LLC · Independence, IAS/N BE17 N4415LIdaho State University · Pocatello, IDS/N BE67 N444RKOrmond Beach Jet LLC · Ormond Beach, FLBuilt 1983 · S/N BE-137 N4490MIndian Ink Leasing Inc · Amarillo, TXBuilt 1979 · S/N BE-64 N487JHCtgx Holdings LLC · Alpine, WYBuilt 1978 · S/N BE-43 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N519RRCgs 2003 LLC · San Leon, TXBuilt 1978 · S/N BE-40 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N54USSilver Eagle Express LLC · Orange, CABuilt 1981 · S/N BE122 N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77 N6045STexoma Building Services LLC · Kingston, OKBuilt 1979 · S/N BE-65 N60TJArk Leasing Inc · Newport Beach, CABuilt 1977 · S/N BE-21 N619DDPark Avenue Group Inc · Stuart, FLBuilt 1980 · S/N BE-92 N627KMSpectre Aviation LLC · Dover, DES/N BE-93 N686ACStm Air LLC · Ocala, FLBuilt 1981 · S/N BE-127 N68MUPark Avenue Group Inc · Stuart, FLBuilt 1978 · S/N BE-37 N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N747EMSal Holdings LLC · Helena, MTBuilt 1983 · S/N BE-136 N770ABAgb Management Inc · Warrenton, VABuilt 1981 · S/N BE121 N770DReynolds Roger David · Key West, FLBuilt 1980 · S/N BE-90 N771CWJ&R Aviation Holdings LLC · Tampa, FLBuilt 1978 · S/N BE-52 N78DARegistered aircraftBuilt 1976 · S/N BE-11 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35 N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91

Back to AD 2004-22-28