Registered aircraft · 2,524

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.

N90210Robertson Crop Dusting Service Inc · South Haven, MIBuilt 1992 · S/N 402-0889 N902AKDillon Aero Inc · Phoenix, AZBuilt 1988 · S/N 560 N902DBBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N LJ1202 N902FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0002 N90319Stevenson Flying Service Ll · Selden, KSBuilt 1999 · S/N 502B-0578 N9032TBarts Flying Service Inc · Storm Lake, IABuilt 2000 · S/N 402A-1130 N9033NJohn Georg Aerial LLC · La Crosse, KSBuilt 1999 · S/N 402A-1097 N9037NOutwest Aviation LLC · Hamilton, MTBuilt 1999 · S/N 802A-0083 N903DPKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 208B0703 N903FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0003 N903JBigups Aviation 010 LLC · Valley Village, CABuilt 2000 · S/N FL-302 N903MDMaryland Department Of Agriculture · Annapolis, MDBuilt 1968 · S/N LM-98 N903SMSterling Air Service LLC · Corpus Christi, TXBuilt 1995 · S/N 131 N90422Kenmore Air Harbor LLC · Kenmore, WABuilt 1955 · S/N 152 N904MCReliant Air Charter Inc · Danbury, CTBuilt 1991 · S/N FL-44 N904PB34 Bravo LLC · Pine Bluff, ARBuilt 1981 · S/N LJ-962 N9053SShearer John W · The Dalles, ORBuilt 1992 · S/N 402-0890 N90614Air Care Systems Inc · Lamar, COBuilt 1999 · S/N 502B-0592 N906FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0006 N906HFCavanaugh Air LLC · Addison, TXBuilt 1971 · S/N LM-140 N906STBthc LLC · Chattanooga, TNBuilt 2005 · S/N 641 N9074HAg Monkey Inc · Norris City, ILBuilt 1999 · S/N 502B-0559 N90772Ag Enterprises LLC · Flagler, COBuilt 1999 · S/N 402A-1112 N907DBErics Leading Edge Inc · St George, UTBuilt 1985 · S/N FA-85 N907EJBarrel King LLC · North Palm Beach, FLBuilt 1997 · S/N FL-161 N907FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0007 N907TRYr Aircraft Leasing LLC · Bethel, AKBuilt 1961 · S/N 1476 N90802Ag Air LLC · Washington, IABuilt 2000 · S/N 802A-0092 N9082CDakota Air Spray LLC · Huron, SDBuilt 1992 · S/N 502-0193 N908FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0008 N908MHMeadows Homes Inc · Cookeville, TNBuilt 2001 · S/N BB-1781 N908TTPrairie Development Company LLC · Gallion, ALBuilt 1991 · S/N FL-67 N90902Midway Air Services Inc · Minter City, MSBuilt 2000 · S/N 502B-0613 N9090MIndependent Dusting Service Inc · El Campo, TXBuilt 2000 · S/N 402B-1122 N9090QWilstine Aviation LLC · Leoti, KSBuilt 1992 · S/N 502-0195 N9090YThiel Air Care Inc · Chowchilla, CABuilt 2000 · S/N 502B-0616 N9091UMeadow Creek Aerial Application Inc · Kelliher, MNBuilt 2000 · S/N 402A-1119 N9094TAcadian Dusters LLC · Church Point, LABuilt 2000 · S/N 502B-0600 N909FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0009 N909PAtlas Property Management LLC · Broken Arrow, OKBuilt 2004 · S/N 4697187 N90ADDalks Leasing Inc · Wilmington, DEBuilt 1991 · S/N 547 N90CNPrice Services Inc · Monticello, ARBuilt 1995 · S/N LJ-1410 N90JFIsr Aviation LLC · Wilmington, DEBuilt 1985 · S/N 20800005 N90NCDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N LJ342 N90PRSfclh LLC · Yukon, OKBuilt 1996 · S/N LJ-1437 N90WJDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-525 N90ZZMckeand Scott · Grant Township, MIBuilt 2005 · S/N 4697223 N9100ZExpress Industries LLC · Prescott Valley, AZS/N 4608014 N91092Wakefield Aircraft LLC · Cooperstown, NDBuilt 1993 · S/N 802A-0005 N910ECState Of Tennessee Department Of Transportation · Nashville, TNBuilt 2004 · S/N 208B1090

Back to AD 2014-17-08 R1