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.

N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N163BALbk Air LLC · Newark, DEBuilt 1984 · S/N FA-18 N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLS/N LJ-1685 N169DRLegacy Aviation LLC · Tea, SDBuilt 1989 · S/N LJ-1205 N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030 N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580 N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647 N16KWWild Blue Aviation LLC · Wilmington, DEBuilt 1996 · S/N LJ-1435 N16TMTriad Physician Resources Inc · Longview, TXBuilt 1998 · S/N LJ-1507 N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226 N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28 N170SEGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1708 N171MSStick Ball Rudder LLC · Bonita Springs, FLBuilt 2002 · S/N LJ-1668 N172EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-172 N172GAAlpine Aviation Inc · Provo, UTS/N UB-11 N173KSCentralav LLC · Lake Worth, FLS/N FA-82 N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028 N174AVUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-174 N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N175EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-175 N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115 N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210 N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76 N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203 N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149 N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178 N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091 N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257 N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318 N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237 N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602 N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634 N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161 N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455 N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68 N184DNorth Country Holdings LLC · Moses Lake, WABuilt 1987 · S/N FA-132

Back to AD 87-22-01 R1