Skip to content

Registered aircraft · 772

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

N125BAAlpine Aviation Inc · Provo, UTS/N UB-6 N125KSAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N BL-125 N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422 N125TSDouble J Aviation Inc · Klamath Falls, ORBuilt 2007 · S/N BB-1993 N126AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC-140 N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76 N127BAAlpine Aviation Inc · Provo, UTS/N UB-7 N128ASParker Robert E · Corpus Christi, TXS/N BB-1950 N128AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC68 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442 N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N130GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-222 N130SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-130 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N132NFlying Cowboys LLC · Merced, CAS/N BB-1053 N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N150KJAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-150 N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216 N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554 N155CJUe-55 LLC · Helena, MTS/N UE-55 N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58 N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157 N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159 N15GABering Air Inc · Nome, AKS/N UE37 N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165

Back to AD 96-09-13