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.

N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218 N532MCAlpha Ag Air LLC · Little River, KSBuilt 2005 · S/N 502B-2594 N53369Poor Boy Aero LLC · Seminole, TXBuilt 2001 · S/N 4697088 N5339G5339g LLC · Vero Beach, FLFirst renewal noticeBuilt 2001 · S/N 4697095 N53516Flight Group LLC · Bend, ORBuilt 2002 · S/N 4697132 N5353VMidwest Ventures LLC · Wichita, KSBuilt 2002 · S/N 4697141 N5355SJohn Galt Industries LLC · Charlevoix, MIBuilt 2002 · S/N 4697136 N535MKCapital Holdings 205 LLC · Northampton, PABuilt 2003 · S/N 535 N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152 N537JFRad Aviation II LLC · Baton Rouge, LABuilt 2004 · S/N 537 N538BHRegistration Pending · Stone Harbor, NJRegistration pendingBuilt 2005 · S/N 626 N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104 N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629 N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426 N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N53KBHiers Properties Of Delaware LLC · Chattanooga, TNBuilt 2005 · S/N 4697231 N53UPhenphilo3 LLC · Wilmington, DEBuilt 2000 · S/N 208B0855 N54199Key Aviation Group LLC · Meridian, MSBuilt 2003 · S/N 4697164 N541PBUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 541 N542AXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-192 N5431MReach Air Medical Services LLC · Santa Rosa, CABuilt 2002 · S/N LJ-1673 N543GATriple A LLC · Savannah, GABuilt 1999 · S/N LJ-1558 N543HCMay Cattle Co LLC · Campbellton, TXBuilt 2001 · S/N LJ-1620 N543TCWonderful Orchards LLC · Shafter, CABuilt 2018 · S/N 20800608 N545GCSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1996 · S/N 208B-0545 N545WBLamy LLC · Alexandria, LABuilt 1996 · S/N 107 N5466RNorthwest Turbine LLC · Spokane, WABuilt 1985 · S/N TJ-497 N546LMAero Air LLC · Hillsboro, ORBuilt 1985 · S/N BB1235 N547PAcqr Leasing LLC · Lake Shore, MNBuilt 1997 · S/N FL185 N548MBSomers Charles · Hillsboro, ORBuilt 1988 · S/N 548 N54CUN54cu Inc Trustee · Wilmington, DEBuilt 2022 · S/N 20800690 N550AHHall Aircraft · Wynne, ARBuilt 2004 · S/N T34HG-104 N550CRCwr Holdings LLC · Wilmington, DEBuilt 2001 · S/N 4697031 N550GCSouth Delta Aviation LLC · Grace, MSBuilt 1997 · S/N 402A-1037 N550HETeufel Nursery Inc · Hillsboro, ORBuilt 1968 · S/N 001 N550HZMaytag David D Jr · Cave Creek, AZBuilt 1972 · S/N 007 N5512BAircraft Structures International Corp · Enid, OKBuilt 1992 · S/N 208B0299 N551CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 1993 · S/N LJ-1347 N552CPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020116 N552PZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 01900008 N555DGBonnie Aero LLC · Dryden, MIBuilt 2013 · S/N 20800547 N555HJFlycarolina King Air Partners LLC · Charlotte, NCBuilt 1994 · S/N LJ-1378 N555VWTp Aviation LLC · Auburn, ALBuilt 1993 · S/N LJ-1330 N555XYNware Aviation Inc · Dover, NHBuilt 1997 · S/N LJ-1488 N556ALEaglemed LLC · Wichita, KSBuilt 1999 · S/N BB-1670 N558BVDt Air LLC · Picayune, MSBuilt 1998 · S/N FL-223 N559BERegistered aircraftBuilt 2024 · S/N 20800708 N559CASky West Aviation Inc Trustee · Albuquerque, NMS/N 213 N55BKPc 12 LLC · Sterling, VABuilt 1996 · S/N 160

Back to AD 2014-17-08 R1