Registered aircraft · 1,915

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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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.

N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-81 N111CAKingmax Aviation LLC · Miami, FLBuilt 1982 · S/N LA-201 N111ENPecos Air Inc · Roswell, NMS/N LA-230 N111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEBuilt 1974 · S/N LW-84 N111KCSherrmore LLC · Winter Park, FLBuilt 1990 · S/N LJ-1258 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111SSFamily Time Machine LLC · Stuart, FLBuilt 1984 · S/N FA-4 N111TCGrady Excavating Inc · Mukilteo, WABuilt 1978 · S/N LW-305 N111YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-111 N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483 N112HGAlghazzawi Hani · Toledo, OHS/N LJ529 N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37 N112YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC112 N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N113AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-41 N114AXAlpine Aviation Inc · Provo, UTBuilt 1988 · S/N UC-36 N114CWMatagorda Production Co · Houston, TXBuilt 1980 · S/N LA97 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 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116 N116TXPlacid Air LLC · Naples, FLBuilt 1999 · S/N BB-1685 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N117AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-79 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N117MFJet Sales Of Stuart LLC · Stuart, FLBuilt 1978 · S/N LJ-779 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N118AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC116 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111 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 N119SAInvestment Opportunities Pursuit LLC · Greenville, NCBuilt 1989 · S/N LJ-1196 N11DTAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-11 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177 N1205SCounty Line Aviation LLC · Benton, KSBuilt 1979 · S/N LW-319 N120NCDavis Aviation Inc DBA · Brandon, MSBuilt 1982 · S/N BB1056 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N120RPMallory & Evans Aviation LLC · Scottdale, GABuilt 1984 · S/N LJ-1075 N120UCAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC120

Back to AD 87-22-01 R1