Registered aircraft · 525

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

N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820 N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689 N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N104KPLakefront Holding LLC · Racine, WIS/N LJ-1719 N1068KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1448 N106DDHlp Aviation LLC · Shreveport, LABuilt 2005 · S/N LJ-1738 N1076KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1461 N1079DGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1462 N1083SGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1443 N1095WEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1456 N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475 N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481 N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486 N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514 N111KCSherrmore LLC · Winter Park, FLBuilt 1990 · S/N LJ-1258 N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483 N112HGAlghazzawi Hani · Toledo, OHS/N LJ529 N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N117MFJet Sales Of Stuart LLC · Stuart, FLBuilt 1978 · S/N LJ-779 N119SAInvestment Opportunities Pursuit LLC · Greenville, NCBuilt 1989 · S/N LJ-1196 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N120RPMallory & Evans Aviation LLC · Scottdale, GABuilt 1984 · S/N LJ-1075 N1212WTwo Drakes Air LLC · Lizella, GABuilt 1994 · S/N LJ-1381 N121JGGo Consultants LLC · Wilmington, DES/N LJ-996 N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520 N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707 N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N127MUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N LJ-1102 N127ZWAerolease LLC · Fargo, NDBuilt 1994 · S/N LJ1369 N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742 N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654 N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721 N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N152WWNardi Greg · Missoula, MTS/N LJ-654

Back to AD 93-17-01