Registered aircraft · 2,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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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.

N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666 N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475 N110PEMission Aviation Fellowship · Nampa, IDBuilt 2000 · S/N 208B0858 N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481 N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486 N1114AEvans David J · Parker, COS/N 208B0309 N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514 N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356 N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402 N1116WAvion Capital Corp · Anchorage, AKBuilt 1994 · S/N 208B0411 N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370 N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111MZCrb Companies LLC · Tulsa, OKBuilt 1998 · S/N FL-210 N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259 N111VRDftf LLC · Des Moines, IABuilt 1991 · S/N 1006 N1120WMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0388 N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483 N1128LArne Aviation LLC · Suffolk, VABuilt 1996 · S/N 208B0536 N1129GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0924 N112LTNorthrop Grumman Systems Corp · El Segundo, CABuilt 2003 · S/N 208B1037 N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N1132FUS Government · Washington, DCBuilt 1999 · S/N 208B0741 N113RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0654 N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N114JPJohnson Airspray Inc · Argyle, MNS/N T34-033 N114PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2021 N114RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0677 N1154FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 208B1065 N115CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0011 N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669 N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152 N115PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2048 N115TTNo Delay LLC · Tickfaw, LABuilt 1992 · S/N FL-74 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N117BBKustatan Leasing LLC · Nikiski, AKBuilt 1962 · S/N 1511 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N117NURegistered aircraftBuilt 1998 · S/N 4636138 N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202 N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019 N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077 N118RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0574 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119

Back to AD 2014-17-08 R1