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.

N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650 N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740 N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344 N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981 N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69 N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774 N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734 N285KCCourt Reporter Assignments Inc · Bullhead City, AZBuilt 2023 · S/N 4698285 N285RBButler National Inc · New Century, KSBuilt 1999 · S/N FL-264 N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134 N288PCWright Air Service Inc · Fairbanks, AKBuilt 2007 · S/N 208B1270 N289ATN999mg LLC · California, MDBuilt 1991 · S/N FL-65 N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540 N290BCTraven Ricardo Siro · Georgetown, SCBuilt 2004 · S/N 1092 N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132 N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519 N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534 N292BWSkyline Aviation Services LLC · Miramar, FLBuilt 2006 · S/N 20800403 N292PSteelman Aviation Inc · Las Vegas, NVBuilt 2005 · S/N 630 N292SSSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 208B1142 N294DRValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4697184 N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094 N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N299MKBoman & Kemp Manufacturing Inc · Ogden, UTBuilt 1990 · S/N BB1357 N299RPGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1537 N299VMSs Leasing LLC · Tulare, CABuilt 1986 · S/N LJ-1125 N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812 N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057 N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539 N2MKItalian Job Holdings LLC · Johnstown, OHBuilt 2003 · S/N 1063 N30019O & K Aviation Inc · Newport, ARS/N T45007DC N3004WMiddle Georgia Aviation Inc · Cochran, GABuilt 1995 · S/N T42209DC N300AEColumbia Asset Trust Corp Trustee · Wichita, KSS/N 97 N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744 N300KAHeartland Aviation LLC · Ada, OKBuilt 1990 · S/N FL-28 N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34 N300TMTaylor & Martin Enterprises Inc · Fremont, NEBuilt 1991 · S/N FL-50 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156 N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221 N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213 N30397Rust Raymond H III · Nacogdoches, TXBuilt 2003 · S/N 4697167 N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581 N303JWKey Investment Holdings LLC · Horseshoe Bay, TXBuilt 2002 · S/N 4697149 N303RRG2 Leasing LLC · Fargo, NDBuilt 1997 · S/N FL-178 N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142 N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495 N3052KUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N UB-70 N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536

Back to AD 2014-17-08 R1