Skip to content

Registered aircraft · 181

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:87-03-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:87-03-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:87-03-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:87-03-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:87-03-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:87-03-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.

N21FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-117 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N223BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-173 N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200 N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223 N225BHUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-181 N226BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-182 N227AVUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-227 N228BHUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-229 N230BHUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-233 N23605Een Aviation LLC · Arlington, TXBuilt 1977 · S/N B-236 N236ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U236 N236CPArtic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-9 N237SLAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U237 N238ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U238 N239ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U239 N248JHExecutive King Air Transportation Inc · Wilmington, DEBuilt 1982 · S/N BE-126 N24EMAsphalt Aviation LLC · Conway, SCBuilt 1976 · S/N BE-6 N24SPUzochi Inc DBA · Albuquerque, NMBuilt 1972 · S/N BB-3 N264PARisk Assumption LLC · Horseshoe Bay, TXBuilt 1980 · S/N BE-86 N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N301TSNeptune Aviation Services Inc · Missoula, MTBuilt 1979 · S/N BE-76 N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N343KKTreeline Transportation Inc · Vance, ALBuilt 1978 · S/N BE-46 N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105 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 N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30 N360BLBachman Aviation LLC · Independence, IAS/N BE17 N370PRPuerto Rico International Airlines Inc · San Juan, PRBuilt 1969 · S/N B-6 N388AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-188 N390RHAlpine Aviation Inc · Provo, UTS/N U-39 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N4299AUas Transervices Inc · Boca Raton, FLBuilt 1971 · S/N U-146 N431RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-71 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 N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92 N479AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1970 · S/N B-96 N487JHCtgx Holdings LLC · Alpine, WYBuilt 1978 · S/N BE-43

Back to AD 87-03-06 R1