# Service difficulty reports: JASC 4970 A list on [JASC 4970](https://openairdocs.org/jasc/4970.md). Reports filed under 4970 · APU Indicating System, newest first. Page 1 of 6 · 272 reports - [SDR SWAA2026101474131](https://openairdocs.org/sdr/SWAA2026101474131.md): Apu · fault message · Oct 10, 2026 · N8841L · Boeing 7378 > APU FAULT LIGHT ILLUMINATED. APU AUTO SHUTDOWN, TURNED APU SWITCH OFF ACCORDING TO QRH. FAULT LIGHT EXTINGUISHED AFTER 3 MIN. FOUND FAULT MSG 49-15003, PERFORMED IFIM TASK 49-10-00-810-803. APU FAULT LIGHT EXTINGUISHED & FAULT NOT ACTIVE MSG CLEARED. - [SDR UIEA2025120501334](https://openairdocs.org/sdr/UIEA2025120501334.md): Warning Message · illuminated · Dec 5, 2025 · N856GT · Boeing 74787UF > EICAS APU INDICATION IN FLIGHT. APU DUCT LEAK STATUS MSG. QRH COMPLIED WITH (APU FIRE HANDLE PULLED)(

OPERATED APU FOR ABOUT 3 HOURS WITH BLEED ON, NO LEAKAGE OBSERVED AND DETECTED REF AMM 49-11-00-862-001. - [SDR ABXA20251019274](https://openairdocs.org/sdr/ABXA20251019274.md): Battery · faulted · Oct 19, 2025 · N1013A · Boeing 76736N > DURING TAXI,APU BATTERY, NO STBY STATUS MESSAGE DISPLAYED. ADVISED BY MTC TO RETURN TO PARKING (BTB). MTX GROUNDED ACFT AND REMOVED AND REPLACED APU BATTERY IAW AMM 24-31-04 AND REMOVED AND REPLACED APU BATTERY CHARGER IAW AMM 24-31-04. OPS CHECK GOOD. ACF - [SDR HALA20250728234](https://openairdocs.org/sdr/HALA20250728234.md): Sensor · failed · Jul 25, 2025 · N396HA · Airbus A330243 > ETOPS - APU AUTO SHUTDOWN. PERFORMED WIRING CHECKS OF SPEED SENSORS 59KV56 AND 59KV57 PER TSM 49-62-00-810-805-A. 59KV26 CONTINUITY GOOD. NO SHORTS TO GND. 59KV57 INTERMITTENT CONTINUITY WHEN TAPPING BEHIND SENSOR CONNECTOR. NO SHORTS TO GROUND. FOUND SPE - [SDR ASAA2023042342988](https://openairdocs.org/sdr/ASAA2023042342988.md): Data Unit · faulty · Apr 23, 2023 · N570AS · Boeing 737890 > DURING APU TROUBLESHOOTING FOUND MESSAGE 49-72103 "DATA MEMORY MODULE CIRCUIT FAILURE". SUSPECT APU WIRING HARNESS. GROUNDED - YES. REF B737-800 FIM 49-70 TASK 806, REMOVED AND REPLACED APU WIRING HARNESS IAW B737-800 AMM 49-011-01. MAINT MSG 49-72103 STILL PR - [SDR ASAA2023022642081](https://openairdocs.org/sdr/ASAA2023022642081.md): Module · faulty · Feb 26, 2023 · N943AK · Boeing 7379 > AIRCRAFT IS REPORTING REPETITIVE APU DMM CIRCUIT FAULT, 49-72105. GROUNDED - YES. PERFORMED TROUBLESHOOTING IAW B737-9 IFIM TASK 49-70-00-810-808. NO FAULTS FOUND. REMOVED AND REPLACED DATA MEMORY MODULE PREXCAUTIONARY IN REFERENCE WITH B737-9 AMM 49-72-11. - [SDR ASAA2022090539823](https://openairdocs.org/sdr/ASAA2022090539823.md): Memory Device · faulted · Sep 5, 2022 · N538AS · Boeing 737890 > APU BITE SHOWS FAULT CODE 49-72101 LAST 18 STARTS. GROUNDED - YES. REMOVED AND REPLACED DATA MEMORY MODULE IAW B737-800 AMM 49-72-11. - [SDR SWIA202266220](https://openairdocs.org/sdr/SWIA202266220.md): Apu · out of adjust · Jul 25, 2022 · N897SK · Cndair CL6002D24 > D: APU DOOR OPEN IN FLIGHT. WOULD NOT CLOSE. / C: DEFERRED APU DOOR OPEN PER MEL 49-14-1B. C/W MX ACTION. PLACARD INSTALLED. / CAT C DUE 8-4-22 / *** SMOD MUST BE CONTACTED BEFORE RETURNED TO SERVICE AFTER REPAIRS ARE COMPLETED DUE TO 2X ODI EVENTS *** / PER - [SDR ASAA2022050438232](https://openairdocs.org/sdr/ASAA2022050438232.md): Module · fault message · May 4, 2022 · N513AS · Boeing 737890 > THE APU FAILED TO START ON TAXI IN. FAULT LIGHT ILLUMINATED. GROUNDED - YES. REMOVED & REPLACED DATA MEMORY MODULE REF B737-800 AMM 49-72-11-000/400-801. FAULT MESSAGE: 49-72101 AND 49-72105 CLEARED. OPS TEST GOOD. APU OPERATES NORMALLY. A/C OK FOR SERVICE - [SDR ASAA2021092536095](https://openairdocs.org/sdr/ASAA2021092536095.md): Warning Light · illuminated · Sep 25, 2021 · N597AS · Boeing 737890 > BLUE MAINT LIGHT ILLUMINATED AFTER STARTING APU ON THE GROUND AFTER LANDING. GROUNDED - YES. APU BITE CHECK SHOWS MAINT MESSAGE 49-72104 DATA MEMORY MODULE SHOW CIRCUIT FAILURE CYCLED POWER TO AIRCRAFT & REPAIR CONFIRMED. CHECKED AND RELEASED PER MEL 49-99A. A - [SDR UIEA2021091102005](https://openairdocs.org/sdr/UIEA2021091102005.md): Fault Message · false activation · Sep 9, 2021 · N640GT · Boeing 7673S1 > APU FAULT MAX EGT 778 RPM 39(

PERFORMED APU ECU BITE CHECK IAW 49-61-05. NO FAULTS PRESENT. PERFORMED OPERATIONAL CHECK OF APU IAW AMM 49-11-00. NO DEFECTS NOTED AT THIS TIME.

) - [SDR ASAA2021090535866](https://openairdocs.org/sdr/ASAA2021090535866.md): Thermocouple · faulted · Sep 5, 2021 · N530AS · Boeing 737890 > APU FAULT X2 APU NOT STARTING. GROUNDED - YES. BITE CHECK C/W. FOUND FAULT MSG 49-491012 TWICE, AND 49-71147 & 49-71148 EGT 1&2 THERMOCOUPLE LOSS OF EGT SHUTDOWN, OPERATED APU, STARTED AND RAN NORMALY. - [SDR UIEA2020122002596](https://openairdocs.org/sdr/UIEA2020122002596.md): Warning Light · false activation · Dec 20, 2020 · N1409A · Boeing 767306 > ITEM 3-APU FAULT ON LANDING/TAXI IN. RE-START OK. PERFORMED BITE CHECK OF THE APU ECU, IAW 49-61-05, NO FAULTS FOUND. OK FOR SERVICE. - [SDR UIEA2020071501555](https://openairdocs.org/sdr/UIEA2020071501555.md): Warning System · false activation · Jul 14, 2020 · N1409A · Boeing 767306 > APU FAULT MESSAGE ON FIRST START ATTEMPT AFTER LANDING, SECOND ATTEMPT STARTED NORMALLY. PERFORMED BITE CHECK OF APU ECU. NO FAULTS FOUND, REF AMM CHAP 49-00-00. - [SDR UIEA2020071401527](https://openairdocs.org/sdr/UIEA2020071401527.md): Warning System · false activation · Jul 10, 2020 · N1373A · Boeing 76731K > APU FAULT AFTER LANDING DURING 1ST START ATTEMPT. RE-START NOT ATTEMPTED. PERFORMED FIM PROCEDURE 49-11 F/T 958, NO FAULTS INDICATED. RESTART SUCCESSFUL. NO DEFECTS NOTED AT THIS TIME. - [SDR ASAA2020070632869](https://openairdocs.org/sdr/ASAA2020070632869.md): Sensor · shorted · Jul 4, 2020 · N519AS · Boeing 737890 > APU FAILURE TO START. FAULT MESSAGE INLET TEMP SENSOR SHOWS SHORT. GROUNDED - YES. REMOVED AND REPLACED APU INLET TEMP SENSOR PER AMM 49-61-31. OPS TEST NORMAL. - [SDR UIEA2020060801217](https://openairdocs.org/sdr/UIEA2020060801217.md): Warning System · false activation · Jun 5, 2020 · N1487A · Boeing 76731K > APU FAULT EICAS MESSAGE WHEN ATTEMPTED START ON TAXI IN. PERFORMED BITE CHECK ON APU ECU, NO FAULTS FOUND. APU STARTED FIRST ATTEMPT REF AMM 49-11-00/49-61-05. - [SDR UIEA2020060101185](https://openairdocs.org/sdr/UIEA2020060101185.md): Warning System · false activation · May 28, 2020 · N1409A · Boeing 767306 > APU FAULT MSG. RECYCLED APU AND PERFORMED BITE TEST. NO FAULTS NOTED AT THIS TIME. EICAS SHOWS NO MESSAGES. APU AND OPERATIONAL IAW AMM 49-11-00 OK FOR SERVICE. - [SDR UIEA2020052901150](https://openairdocs.org/sdr/UIEA2020052901150.md): Warning System · false activation · May 28, 2020 · N649GT · Boeing 767375 > APU FAULT DURING APU START. PERFORMED APU BITE TEST IAW FIM 49-11 FT 958, FOUND FAULT 34, CLEARED. PERFORMED OPERATIONAL TEST, OK IAW AMM 49-11-00. - [SDR ASAA2020051732740](https://openairdocs.org/sdr/ASAA2020051732740.md): Warning System · false activation · May 17, 2020 · N487AS · Boeing 737990ER > CSS FAILED FL 400 (3 ATTEMPTS), FAULT LIGHT ILLUMINATED. GROUNDED - YES. FOUND FAULT 49-31016 OVERTEMP SHUTDOWN. IAW FIM TASK 49-30 TASK 803, STARTED APU NO FAULTS NOTED. APU COLD SOAK START ACCOMPLISHED, SUCCESSFUL. - [SDR UIEA2020050400940](https://openairdocs.org/sdr/UIEA2020050400940.md): Warning System · false activation · May 3, 2020 · N645GT · Boeing 767324 > APU FAULT ON LANDING.(

FOLLOWED FAULT TREE FIM 49-11 FT 987 - FOR APU ECU BITE - NO DATA DISPLAYED.

APU OPERATING NORMALLY AT THIS TIME IAW AMM 49-11-00.

) - [SDR UIEA2020042900914](https://openairdocs.org/sdr/UIEA2020042900914.md): Warning System · false activation · Apr 28, 2020 · N1427A · Boeing 767306 > APU FAULT (

BEGAN APU BITE PROCEDURE. PERFORMED TWO SUCCESSFUL STARTS DURING OPS CHECK IAW AMM 49-11-00. OPS CHECK WAS GOOD.

) - [SDR UIEA2020042800882](https://openairdocs.org/sdr/UIEA2020042800882.md): Warning System · false activation · Apr 28, 2020 · N1373A · Boeing 76731K > STARTED APU AFTER LANDING. IT WAS RUNNING WHEN WE BLOCKED IN. WHEN WE SHUTDOWN ENGINES APU FAULT CAME ON AND APU SHUTDOWN.(

INTERROGATED BPCU, NO FAULT FOUND. APU OPS CHECK NORMAL AT THE PRESENT TIME IAW 49-11-00.

) - [SDR UIEA2020042800880](https://openairdocs.org/sdr/UIEA2020042800880.md): Warning System · false activation · Apr 27, 2020 · N1373A · Boeing 76731K > APU FAULT EICAS.(

PERFORMED BITE ON APU MODULE AND FOUND NO FAULTS ON LRU OR PREVIOUS FAULT HISTORY IAW B767 AMM 49-61-05. RAN APU AND APPLIED ELECTRIC LOAD AND OBSERVED NO ABNORMAL ACTIVITY. OPS CHECK GOOD.

) - [SDR UIEA2020042700842](https://openairdocs.org/sdr/UIEA2020042700842.md): Warning System · false activation · Apr 26, 2020 · N1499A · Boeing 767328 > APU BLEED VALVE MESSAGE DISPLAYED.(

PERFORMED PNEUMATIC SYSTEM TEST IAW AMM 49-11-00. SYSTEM TEST OK.

) - [SDR UIEA2020042800837](https://openairdocs.org/sdr/UIEA2020042800837.md): Warning System · false activation · Apr 25, 2020 · N645GT · Boeing 767324 > APU FAULT ON LANDING.(

PERFORMED APU BITE PER FIM 49-11 FT 987, NO FAULTS NOTED AT THIS TIME. OPS CHECK GOOD PER B767 AMM 49-11-00.

) - [SDR UIEA2020041600756](https://openairdocs.org/sdr/UIEA2020041600756.md): Unknown · malfunctioned · Apr 16, 2020 · N1373A · Boeing 76731K > APU FAULT ON ARRIVAL(

PERFORM APU BITE TEST REF AMM 49-61-05-742-027. NO FAULTS NOTED AT THIS TIME.

) - [SDR UIEA2020032300534](https://openairdocs.org/sdr/UIEA2020032300534.md): Unknown · malfunctioned · Mar 23, 2020 · N1373A · Boeing 76731K > APU FAULT EICAS MSG, 2ND ATTEMPT UNSUCCESSFUL, APU FAULT ON THE 2ND ATTEMPT.(

TRANSFERRED TO MDDR 126159, CAT C, PER DDG 49-11-01A, CAT C DUE 02APR20.

LOG PAGE 1071564: PERFORMED BITE ON APU ECU I.A.W 49-61-05. NO FAULTS FOUND. ALSO PERFORMED 3 OPS CHE - [SDR UIEA2020032300533](https://openairdocs.org/sdr/UIEA2020032300533.md): Warning System · false activation · Mar 23, 2020 · N1373A · Boeing 76731K > APU FAULT(

PERFORMED APU ECU BITE CHECK IAW B767 FIM 49-11 FT 958, SYSTEM FAULTED PT SENSOR MINI FLAG 14. RESET, CLEARED. NO REPEAT, SYSTEM OPERATES NORMAL. NO FURTHER DEFECTS NOTED UPON INSPECTION.

) - [SDR UIEA2020032000501](https://openairdocs.org/sdr/UIEA2020032000501.md): Warning System · false activation · Mar 19, 2020 · N1373A · Boeing 76731K > APU FAULT EICAS MESSAGE AFTER LANDING, TWO START ATTEMPTS MADE.(

3RD ATTEMPT START SUCCESSFUL. PERFORMED BITE CHECK OF ECU, NO FAULTS FOUND I.A.W AMM 49-11-00. OPS CHECK GOOD.

) - [SDR UIEA2020031900493](https://openairdocs.org/sdr/UIEA2020031900493.md): Warning System · false activation · Mar 17, 2020 · N1487A · Boeing 76731K > APU FAULT AFTER TAXI TO GATE.(

PERFORMED APU START I/A/W AMM 49-11-00. NO DEFECTS NOTED, OPS CHECK NORMAL.

) - [SDR UIEA2020031100430](https://openairdocs.org/sdr/UIEA2020031100430.md): Warning System · false activation · Mar 11, 2020 · N1373A · Boeing 76731K > APU FAULT, SECOND ATTEMPT SUCCESSFUL.(

PERFORMED APU ECU BITE PROCEDURE IAW AMM 49-61-05, NO FAULTS FOUND. ALL TESTS CHECK OK. PERFORMED APU OPERATIONAL CHECK IAW AMM 49-11-00, OPS CHECK GOOD AT THIS TIME.

) - [SDR ASAA2020030932387](https://openairdocs.org/sdr/ASAA2020030932387.md): Warning System · false activation · Mar 6, 2020 · N462AS · Boeing 737990ER > APU "FAULT" LIGHT ILLUMINATED AT APU START PER QRH ATTEMPTED 2ND START AFTER FAULT LIGHT EXTINGUISHED 2ND STARTED SUCCESSFUL. GROUNDED - YES. PERFORMED APU BITE TEST FOUND FAULT 49-41010. STARTED APU AND FAULT LIGHT REMAINED EXTINGUISH. CSS APU PASSED. - [SDR ASAA2020030232300](https://openairdocs.org/sdr/ASAA2020030232300.md): Sensor · malfunctioned · Feb 26, 2020 · N286VA · Airbus A320214 > APU AUTO SHUT DOWN, TWO ATTEMPTS. HAS HISTORY GROUNDED - YES. TURN APU MASTER SWITCH ON DO NOT START ACCESS APU SHUTDOWN DATA FROM THE APU PAGE ON MCDU AND UPDATE TROUBLESHOOTING TO ORDER PARTS.APU SHUTDOWN IS NOT BEING REPORTED TO PTMD R&R APU SPEED SENSOR, A - [SDR ASAA2020021863200](https://openairdocs.org/sdr/ASAA2020021863200.md): Fault Light · false activation · Feb 16, 2020 · N402AS · Boeing 737990ER > APU FAULT LT ILLUMINATED ON 1ST ATTEMPT AT 340 APU FAULT LT ILLUMINATED ON 2ND ATTEMPT AT 360 3RD ATTEMP AT 340 - PASSED. GROUNDED - YES. APU BITE SHOWS MAINT MSG 49-41010 IN HISTORY, APU OPS CHECK GOOD ON GROUND. - [SDR ASAA2020021843201](https://openairdocs.org/sdr/ASAA2020021843201.md): Fault Light · false activation · Feb 14, 2020 · N462AS · Boeing 737990ER > APU FAULT ILLUMINATED WHEN ATTEMPTING START AFTER LANDING 2ND TRY SUCCESSFUL. GROUNDED - YES. APU STARTS NORMAL NO FAULTS NOTED. - [SDR ASAA2020010931788](https://openairdocs.org/sdr/ASAA2020010931788.md): Warning System · false activation · Jan 5, 2020 · N462AS · Boeing 737990ER > UPON LANDING AND STARTING APU, "FAULT" LIGHT ILLUMINATED. GROUNDED - YES. UPON ARRIVING TO AIRCRAFT, STARTED APU FOUR TIMES, ALL FOUR STARTS WERE NORMAL. REF B737-900 FIM 49-60 TASK 801 FOUND "MAINT MSG 49-41010" IN FAULT HISTORY JAN05. CURRENT STATUS SHOW'S " - [SDR UIEA2019112535950](https://openairdocs.org/sdr/UIEA2019112535950.md): Warning Message · false activation · Nov 23, 2019 · N1487A · Boeing 76731K > APU FAULT.(

PERFORMED BITE CHECK OF THE APU IAW FIM 49-11 FT 987, MESSAGE CLEARED.

) - [SDR ASAA2019103081176](https://openairdocs.org/sdr/ASAA2019103081176.md): Module · faulted · Oct 28, 2019 · N419AS · Boeing 737990ER > APU CSS FAILED FL350, FL350 AND FL310. APU FAULT LIGHT ILLUMINATED. APU OPERATES NORMALLY ON THE GROUND. GROUNDED - YES. PREFORMED APU BITE FOUND FAULT MSG 49-72104 DMM MODULE FAULT, PREFORMED APU START ON GND PER B737-900 AMM 49-11-00 APU START NORMAL, NO FAU - [SDR HALA2019092400384](https://openairdocs.org/sdr/HALA2019092400384.md): Sensor · malfunctioned · Sep 24, 2019 · N360HA · Airbus A330243 > ETOPS SIGNIFICANT SYSTEM - APU FAULT AUTO SHUTDOWN ON TAXI IN. REMOVED AND REPLACED APU HIGH OIL TEMP SENSOR PER AMM 49-94-13. OPS CHECK LEAK CHECK OK. - [SDR UIEA2019092505573](https://openairdocs.org/sdr/UIEA2019092505573.md): Warning System · false activation · Sep 24, 2019 · N1321A · Boeing 767306 > MAINT MSG, APU DOOR. IMPROPER APU SHUTDOWN. CLOSED APU DOOR, APU START NORMAL IAW AMM 49-11-00. - [SDR ASAA2019092130776](https://openairdocs.org/sdr/ASAA2019092130776.md): Warning System · false activation · Sep 21, 2019 · N472AS · Boeing 737990ER > FAULT LIGHT ILLUMINATED DURING APU START ATTEMPT AT FL 340. GROUNDED - YES. ACCOMPLISHED FIM 49-30 TASK 804 INITIAL EVAL PASS. MSG 49-31018 WAS SHOWING BEFORE ACCOMPLISHING THE FIM TASK. AFTER APU START AND SHUTDOWN, NO MSG WAS SHOWING FOR THE LAST APU CYCLE. - [SDR UIEA2019091605513](https://openairdocs.org/sdr/UIEA2019091605513.md): Warning System · false activation · Sep 15, 2019 · N1487A · Boeing 76731K > EICAS MSG: APU FAULT. PERFORMED BITE OF APU ECU, NO FAULTS FOUND. OPS CHECK GOOD REF AMM 49-61-05. - [SDR HNAA2019091300268](https://openairdocs.org/sdr/HNAA2019091300268.md): Warning System · false activation · Sep 12, 2019 · N624AE · Emb EMB145LR > PDIS 624 49-10 1881591 12SEP19 PHL CLOSE APU FAIL MESSAGE ON EICAS. 28876 00 MDC FACT 12SEP19 19:23 PHL PERFORMED ELECTRICAL RESET, OPERATED APU FOR 30 MINS WITH BOTH PACKS ON. OPS NORMAL, OK FOR SERVICE. - [SDR UIEA2019090905473](https://openairdocs.org/sdr/UIEA2019090905473.md): Warning System · false activation · Sep 9, 2019 · N1619A · Boeing 7673Y0 > APU FAULT MESSAGE ON LOWER EICAS. PERFORMED APU CONTROL UNIT BITE TEST IAW AMM 49-61-05 - FAULT NO LONGER PRESENT. PERFORMED APU START IAW AMM 49-11-00 NO FAULTS NOTED. NOTE: PER MCC REQUEST - AN APU COLD SOAK START VERIFICATION DEFERRAL WAS OPENED (MDDR 11752 - [SDR UIEA2019090705455](https://openairdocs.org/sdr/UIEA2019090705455.md): Warning System · false activation · Sep 7, 2019 · N645GT · Boeing 767324 > APU FAULT, 3RD ATTEMPT AT 17:23Z. CLEARED FAULT. OPS CHECK COMPLIED WITH, APU START IAW 49-60-00. - [SDR UIEA2019083105418](https://openairdocs.org/sdr/UIEA2019083105418.md): Unknown · malfunctioned · Aug 31, 2019 · N1499A · Boeing 767328 > APU FAULT X3. PERFORMED APU/ECU BITE CHECK PER FIM 49-11-00. NO FAULTS FOUND AT THIS TIME. - [SDR ASAA2019072930233](https://openairdocs.org/sdr/ASAA2019072930233.md): Status Message · false activation · Jul 29, 2019 · N566AS · Boeing 737890 > FOUND APU CURRENT STATUS MESSAGE 49-94304. NO APU START FAULTS FOUND. APU STARTED AND RAN NORMALLY. GROUNDED - YES. PER FIM 49-90 TASK 811 INITIAL EVALUATION FAULT NO LONGER SHOWS IN CURRENT STATUS AND IS CONSIDERED INTERMITTENT. NO MAINT ACTION REQUIRED. - [SDR ASAA2019072830232](https://openairdocs.org/sdr/ASAA2019072830232.md): Sensor · corroded · Jul 28, 2019 · N596AS · Boeing 737890 > APU TREND DATA SHOWS CT5ATP TEMP IS AT OR ABOVE THE THRESHOLD 605 DEGREES GROUNDED - YES. NO RECENT RELATED MTX MESSAGES IN APU HISTORY. NO BLOCKAGE IN AIR INLET OR COMPRESSOR INLET PLENUM. REMOVED INLET TEMP SENSOR & FOUND IT TO BE CORRODED & DIRTY. CLEANED C - [SDR UIEA2019071904794](https://openairdocs.org/sdr/UIEA2019071904794.md): Warning System · false activation · Jul 19, 2019 · N1487A · Boeing 76731K > APU FAULT EICAS MESSAGE. (

PERFORMED ECU BITE IAW AMM 49-61-05, NO FAULTS NOTED. TEST OK, APU START 2ND ATTEMPT. PILOT WAS 1ST ATTEMPT.

) Next page: https://openairdocs.org/jasc/4970/reports.md?page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '4970' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/jasc/4970/reports --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.