Registered aircraft · 2,358

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:98-15-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:98-15-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:98-15-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:98-15-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:98-15-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:98-15-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.

N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216 N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554 N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286 N1560Davis Aviation Inc · Brandon, MSS/N BC-09 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N156LAFresno Beverage Co Inc DBA · Fresno, CABuilt 2018 · S/N FL-1153 N156TMWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N FL-518 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N15WCDakota Aviation LLC · Santa Ana, CABuilt 2016 · S/N FL-1063 N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226 N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215 N161VDepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N FM-52 N162GDepartment Of Homeland Security · Washington, DCBuilt 2017 · S/N FM-72 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 N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165 N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147 N166CLKa Partners LLC · Thomson, GABuilt 2000 · S/N FL-298 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N167CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N FM-86 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 N173BDept Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-84 N173KSCentralav LLC · Lake Worth, FLS/N FA-82 N173MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1151 N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028 N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N175PLTp Air LLC · Laredo, TXBuilt 2019 · S/N FL-1187 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 N177GATippen Steel Services Inc · Boyd, TXBuilt 1997 · S/N FL-160

Back to AD 98-15-13