Registered aircraft · 816

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-01-10') 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-01-10') 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-01-10')
    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-01-10')
  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-01-10')
  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-01-10')
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.

N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742 N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49 N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 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 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 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 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N152WWNardi Greg · Missoula, MTS/N LJ-654 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 N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736 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 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 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115 N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76 N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149 N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091 N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318 N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237 N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455 N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842

Back to AD 2002-01-10