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.

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-100 N100VGMarmentini Rosecler Catuzzo · Houston, TXS/N UC92 N101SGSe Aviation LLC · Tupelo, MSBuilt 2001 · S/N BB-1785 N101UEAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-101 N102DBFinch Air LLC · Midland, TXBuilt 1996 · S/N BB1537 N103SFAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-103 N104BEUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-221 N104CXSli Aircraft Leasing Inc · Spokane Valley, WABuilt 1982 · S/N BB1004 N105EV2nd Amendment Wholesale Inc · Grand Forks, NDS/N UE-64 N106GBHardhead Aviation LLC · Midland, TXBuilt 1986 · S/N BB-1249 N106SXUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-166 N1074GEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1534 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N108RJDixon John W · Aurora, ORBuilt 2002 · S/N BB-1801 N108SXUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-184 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213 N10CW911 Aviation LLC · Durant, OKBuilt 1985 · S/N BB-1211 N10QWBlackhawk 04 LLC · Portland, ORS/N BB-1846 N110AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC-93 N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N111AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-81 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-111 N112YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC112 N113AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-41 N114AXAlpine Aviation Inc · Provo, UTBuilt 1988 · S/N UC-36 N114HBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1533 N115AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-2 N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669 N116TXPlacid Air LLC · Naples, FLBuilt 1999 · S/N BB-1685 N117AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-79 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N118AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC116 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N119ARCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N BB-1867 N119AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-43 N119MCAgave III LLC · Seattle, WABuilt 1985 · S/N BB-1225 N120NCDavis Aviation Inc DBA · Brandon, MSBuilt 1982 · S/N BB1056 N120UCAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC120 N121DKAutomotive Air II LLC · Belcamp, MDBuilt 2007 · S/N BB-1995 N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651 N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122 N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587 N124AXAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC158 N124GADriscoll Health Care Services · Corpus Christi, TXBuilt 1982 · S/N BB-1039 N124GPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-23 N125AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC44

Back to AD 96-09-13