Skip to content

Registered aircraft · 280

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

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 N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N119SAInvestment Opportunities Pursuit LLC · Greenville, NCBuilt 1989 · S/N LJ-1196 N120RPMallory & Evans Aviation LLC · Scottdale, GABuilt 1984 · S/N LJ-1075 N1212WTwo Drakes Air LLC · Lizella, GABuilt 1994 · S/N LJ-1381 N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520 N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655 N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669 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 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 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214 N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736 N1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLS/N LJ-1685 N169DRLegacy Aviation LLC · Tea, SDBuilt 1989 · S/N LJ-1205 N16KWWild Blue Aviation LLC · Wilmington, DEBuilt 1996 · S/N LJ-1435 N16TMTriad Physician Resources Inc · Longview, TXBuilt 1998 · S/N LJ-1507 N170SEGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1708 N171MSStick Ball Rudder LLC · Bonita Springs, FLBuilt 2002 · S/N LJ-1668 N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091 N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318 N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455 N190SSJ&H Kramer Inc · Redwood City, CABuilt 1992 · S/N LJ1298 N190XTNextant Aerospace LLC · Cleveland, OHBuilt 1984 · S/N LJ-1066 N197SCCharlie Ninety Alpha LLC · Searcy, ARBuilt 1997 · S/N LJ-1490 N199CGGuardian Flight LLC · Lewisville, TXBuilt 2002 · S/N LJ-1661

Back to AD 2002-09-12