# Service difficulty reports: N8783E A list on [N8783E](https://openairdocs.org/aircraft/N8783E.md). Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first. Page 1 of 3 · 113 reports - [SDR REXA2022100302167](https://openairdocs.org/sdr/REXA2022100302167.md): None · corroded · Sep 29, 2022 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CORROSION FOUND ON CARGO FLOOR BEAM AT RBL27 BETWEEN FS605-FS621 REPAIRED SEAT RAIL 601R35031-263 AND FLOOR BEAM FITTING 601R35289-4 - [SDR REXA2022100302164](https://openairdocs.org/sdr/REXA2022100302164.md): Fitting · cracked · Sep 2, 2022 · N8783E · Cndair CL6002B19 · Fuselage Main, Structure > RH SIDE SIDE WINDSHIELD POST HAS CRACK AT LOWER AFT CLIP RADIUS. REMOVED AND INSTALLED NEW R/H SIDE WINDSHIELD POST AFT FITTING REF CRJ-200 SRM 51-42-21 AND DWG 601R33007 REV -U - [SDR REXA2022100302169](https://openairdocs.org/sdr/REXA2022100302169.md): None · corroded · Aug 27, 2022 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > FOUND CORROSION ON RBL 9 FLOOR BEAM FLANGE AT FS 559+64 - FS 559+112 REMOVED CORROSION ON FLOOR BEAM AT RBL9 FROM FS 559+16 TO FS 559+80 REF CRJ 200 SRM 51-21-06. FOUND TO BE OUT OF LIMITS REF CRJ 200 SRM 53-00-00 PGS 101-106 AND CRJ 200 SRM 53-51-43. REPLACED - [SDR REXA2022100302168](https://openairdocs.org/sdr/REXA2022100302168.md): Strap · corroded · Aug 27, 2022 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CORROSION ON FLOOR STRAP BETWEEN RBL9 AND RBL27 AT FS559+48 REMOVED AND REPLACED FLOOR STRAP AT FS559+48 BETWEEN RBL9 & RBL27 WITH NEW P/N: 601R32215-43 REF CRJ200 SRM 51-42-06 DUE TO 100% MATERIAL LOSS - [SDR REXA2022100302166](https://openairdocs.org/sdr/REXA2022100302166.md): None · corroded · Aug 22, 2022 · N8783E · Cndair CL6002B19 · Fuselage Main, Structure > LH PRESSURE FLOOR SILL ANGLE HAS SEVERAL AREAS OF CORROSION AROUND FS 409.00+128 - FS 559.00 REPAIRED PER CRJ253-14480 REV A DATED 09/23/2022. - [SDR REXA2022100302165](https://openairdocs.org/sdr/REXA2022100302165.md): Skin · worn · Aug 17, 2022 · N8783E · Cndair CL6002B19 · Wing, Control Surfaces > RH OUTBD FLAP HAS NUMEROUS SMOKING RIVETS ON UPPER SKIN REPAIRED RH OUTBD FLAP NUMEROUS SMOKING RIVETS ON UPPER SKIN REF EA CRJ257-14441 REV. A DATED: 09/09/2022 - [SDR REXA2022100302163](https://openairdocs.org/sdr/REXA2022100302163.md): Bracket · worn · Aug 13, 2022 · N8783E · Cndair CL6002B19 · Wing, Control Surfaces > RIGHT INBOARD FLAP INBD ATTACHMENT BRACKET ON THE INBD HINGE ARM CHAFED FOUND TO BE OUT OF LIMITS IAW CRJ 200 SRM 57-54-00, INSTALLED NEW ATTACHMENT BRACKET P/N: 601R14116-85 CRJ 200 SRM 51-42-06 AND CRJ 200 SRM 51-45-00 - [SDR REXA2022100302162](https://openairdocs.org/sdr/REXA2022100302162.md): Separator · worn · Aug 13, 2022 · N8783E · Cndair CL6002B19 · Nacelle/Pylon Structure > PANEL 422DB HAS BOTH SEPARATORS KNIFE-EDGED REMOVED AND INSTALLED (2) EA NEW SEPARATORS P/N: 601R37138-24 AND -26 ON PANEL 422DB REF CRJ200 SRM 51-42-06 - [SDR REXA2022100302161](https://openairdocs.org/sdr/REXA2022100302161.md): Separator · worn · Aug 13, 2022 · N8783E · Cndair CL6002B19 · Nacelle/Pylon Structure > PANEL 412DB HAS BOTH SEPARATORS KNIFE-EDGED REMOVED AND INSTALLED (2) EA NEW SEPARATORS P/N: 601R37138-25 AND -27 ON PANEL 412DB REF CRJ200 SRM 51-42-06 - [SDR REXA2021090820703](https://openairdocs.org/sdr/REXA2021090820703.md): Charger · inoperative · Sep 2, 2021 · N8783E · Cndair CL6002B19 · Emergency Lighting > EMERGENCY LIGHT SYSTEM IS BURNT OUT FROM ROW 2-6. R/R #2 CHARGER ASSY AND #2 BATTERY PACK IAW AMM 33-51-05 AND 33-51-04. OPS TEST INTERIOR AND EXTERIOR EMERGENCY LIGHTS NORMAL. - [SDR REXA2019090401283](https://openairdocs.org/sdr/REXA2019090401283.md): Fuel Line · faulty · Sep 4, 2019 · N8783E · Cndair CL6002B19 · APU Engine Fuel and Control > STRONGFUEL SMELL FROM PACKS WHEN APU IS RUNNING. REMOVED AND REPLACED APU FUEL LIKE TUBE ASSY AND RIGHT AND LEFT WATER SEPARATOR COALESCER BAG IAW CMM 49-26-43 AND AMM 21-51-13 OPS CK GOOD AT THIS TIME. - [SDR REXA2019061710841](https://openairdocs.org/sdr/REXA2019061710841.md): Retainer · cracked · Jun 11, 2019 · N8783E · Cndair CL6002B19 · Emergency Exits > SEAL RETAINER IS CRACKED ON LEFT HAND OVERWING ESCAPE DOOR. - [SDR REXA2019060600838](https://openairdocs.org/sdr/REXA2019060600838.md): Support Angle · cracked · Jun 6, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > RH ACM RACK LWR PRSOV SUPPORT ANGLE CRACKED. REMOVED CRACKED SUPPORT ANGLE AND INSTALLED NEW ANGLE IAW SRM 51-42-06 - [SDR REXA2019060600836](https://openairdocs.org/sdr/REXA2019060600836.md): Beam · chafed · Jun 6, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > LH IB FLAP OB VANE ACTUATOR BEAM CHAFED UNDER ROLLER. LH I/B FLAP O/B VANE ACTUATOR BEAM REPAIRED IAW REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801 AAR AP 453 - [SDR REXA2019061360834](https://openairdocs.org/sdr/REXA2019061360834.md): Beam · chafed · Jun 6, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > RH IB FLAP IB VANE ACTUATOR BEAM CHAFED UNDER ROLLER. RH I/B FLAP I/B VANE ACTUATOR BEAM REPAIRED IAW BOMBARDIER REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801. - [SDR REXA2019061360829](https://openairdocs.org/sdr/REXA2019061360829.md): Doubler · cracked · Jun 6, 2019 · N8783E · Cndair CL6002B19 · Fuselage Main, Plate/Skin > AC GROUND POWER DOOR 122BR LANDING, FWD EDGE IS MISSING. REPAIRED AC GROUND POWER DOOR 122BR LANDING, FWD EDGE I.A.W. BOMBARDIER REO 601R53-11-569 - [SDR REXA2019061350835](https://openairdocs.org/sdr/REXA2019061350835.md): Beam · chafed · Jun 5, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > RH IB FLAP MID VANE ACTUATOR BEAM CHAFED UNDER ROLLER. REPAIRED CHAFE ON RH I/B FLAP MID VANE ACTUATOR BEAM UNDER ROLLER IAW BOMBARDIER REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801 AAR SM 107 - [SDR REXA2019061350833](https://openairdocs.org/sdr/REXA2019061350833.md): Beam · chafed · Jun 5, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > RH IB FLAP OB VANE ACTUATOR BEAM CHAFED UNDER ROLLER. REPAIRED CHAFE UNDER ROLLER ON RH O/B VANE ACTUATOR BEAM ON I/B FLAP RH IAW BOMBARDIER REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801 - [SDR REXA2019061350832](https://openairdocs.org/sdr/REXA2019061350832.md): Beam · chafed · Jun 5, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > LH IB FLAP MID VANE ACTUATOR BEAM CHAFED UNDER ROLLER. REPAIRED CHAFE ON LH I/B FLAP MID VANE ACTUATOR BEAM UNDER ROLLER IAW REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801 AAR SM 107 - [SDR REXA2019061350831](https://openairdocs.org/sdr/REXA2019061350831.md): Beam · chafed · Jun 5, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > LH IB FLAP IB VANE ACTUATOR BEAM CHAFED UNDER ROLLER. REPAIRED CHAFE UNDER ROLLER ON LH I/B FLAP VANE ACTUATOR BEAM IAW BOMBARDIER REO 601R-57-52-1979 OPS/CLEARANCE CHECK GOOD IAW CRJ 200 AMM 27-54-15-820-801 AND 27-54-00-710-801 - [SDR REXA2019061340840](https://openairdocs.org/sdr/REXA2019061340840.md): Structure · cracked · Jun 4, 2019 · N8783E · Cndair CL6002B19 · Passenger/Crew Doors > PAX DOOR UPPER EDGE MEMBER IS CRACKED AT THE AFT SIDE, UNDER TOP STEP 832ET. REPAIRED PAX DOOR UPPER EDGE MEMBER IAW REO 601R-52-11-279 - [SDR REXA2019061340839](https://openairdocs.org/sdr/REXA2019061340839.md): Drag Angle · cracked · Jun 4, 2019 · N8783E · Cndair CL6002B19 · Passenger/Crew Doors > PAX DOOR AFT DRAG ANGLE CRACKED - REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513 - [SDR REXA201906130824](https://openairdocs.org/sdr/REXA201906130824.md): Seal · worn · Jun 3, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon, Main Frame > R/H UPPER CORE COWL T/E IS CHAFED, REMOVED OLD AND INSTALLED NEW CLOSURE RING IAW BOMBARDIER CMM 71-12-01. - [SDR REXA2019061310830](https://openairdocs.org/sdr/REXA2019061310830.md): Plate · chafed · May 31, 2019 · N8783E · Cndair CL6002B19 · Trailing Edge Flaps > FLAP FAIRING 692BB HAS CHAFFED GUIDE PLATE. REMOVED/INSTALLED NEW GUIDE PLATE ON PANEL 692BB IAW CRJ 200 SRM 51-42-06 - [SDR REXA2019061310825](https://openairdocs.org/sdr/REXA2019061310825.md): Angle · cracked · May 31, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon Miscellaneous Structure > PYLON PANEL 422BT SEAL RETAINER IS CRACKED. REMOVED & REPLACED SEAL RETAINER IAW CMM 20-42-06. - [SDR REXA2019061300837](https://openairdocs.org/sdr/REXA2019061300837.md): Angle · cracked · May 30, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > WHILE PERFORMING INSPECTION OF PRESSURE FLOOR SKIN, NOTED ANGLE CRACKED AF FS484, LBL27. REMOVED/REPLACED CLIP ANGLE AT FS 484 LBL 27 IAW CRJ 200 SRM 51-42-06 AND 51-42-21 - [SDR REXA2019061300827](https://openairdocs.org/sdr/REXA2019061300827.md): Retainer · cracked · May 30, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon Miscellaneous Structure > PYLON ACCESS PANEL 422DB SEAL RETAINER IS CRACKED. REMOVED AND REPLACED SEAL RETAINER IAW CRJ-200 SRM-51--42-06. - [SDR REXA2019061300826](https://openairdocs.org/sdr/REXA2019061300826.md): Retainer · cracked · May 30, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon, Main Frame > PYLON ACCESS PANEL 422DB SEAL RETAINER IS CRACKED. REMOVED AND REPLACED SEAL RETAINER IAW SRM-51-42-06. - [SDR REXA2019061300823](https://openairdocs.org/sdr/REXA2019061300823.md): Angle · cracked · May 30, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > WHILE PERFORMING INSPECTION OF PRESSURE FLOOR SKIN, NOTED ANGLE CRACKED AF FS484, LBL27 - REMOVED/REPLACED CLIP ANGLE AT FS 484 LBL 27 IAW CRJ 200 SRM 51-42-06 AND 51-42-21. - [SDR REXA2019061329828](https://openairdocs.org/sdr/REXA2019061329828.md): Angle · cracked · May 29, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > WHILE PERFORMING INSPECTION OF PRESSURE FLOOR SKIN, NOTED ANGLE AT FS484, RBL27 CRACKED. REMOVED & REPLACED CLIP ANGLE AT FS484 RBL27 IAW CRJ 200 SRM 51-42-21. - [SDR REXA2019061370821](https://openairdocs.org/sdr/REXA2019061370821.md): Strap · corroded · May 27, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > WHILE ACCESSING INSPECTION AREA, NOTED FLOOR SUPPORT STRAP AT FS559.00 LBL36 IS CORRODED. REMOVED AND REPLACED FLOOR SUPPORT STRAP @ 559 LBL 36 IAW CRJ200 SRM 51-42-06 - [SDR REXA2019061370820](https://openairdocs.org/sdr/REXA2019061370820.md): Strap · corroded · May 27, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > WHILE ACCESSING INSPECTION AREA, NOTED FLOOR SUPPORT STRAP AT FS559.00 RBL36 IS CORRODED. REMOVED AND REPLACED FLOOR SUPPORT STRAP AT BS 559, RBL 36 IAW SRM 51-42-06. - [SDR REXA2019052600819](https://openairdocs.org/sdr/REXA2019052600819.md): Rub Strip · chafed · May 26, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon, Plate/Skin > PYLON ACCESS PANEL 422DB FIRE SHIELDS ARE CHAFFED. REMOVED AND REPLACED FIRE SHIELDS AND RUBSTRIPS IAW CRJ200 SRM 51-42-13 - [SDR REXA2019061360818](https://openairdocs.org/sdr/REXA2019061360818.md): Rub Strip · chafed · May 26, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon, Plate/Skin > PYLON ACCESS PANEL 412DB FIRE SHIELDS ARE CHAFED. REMOVED AND REPLACED FIRESHIELDS AND RUBSTRIPS IAW CRJ200 SRM 51-42-13 - [SDR REXA2019613050822](https://openairdocs.org/sdr/REXA2019613050822.md): Retainer · cracked · May 25, 2019 · N8783E · Cndair CL6002B19 · Nacelle/Pylon, Plate/Skin > PYLON ACCESS PANEL 412BT HAS CRACKED SEAL RETAINER. REMOVED AND REPLACED SEAL RETAINER IAW CRJ200 SRM 51-42-06 - [SDR REXA2019061340817](https://openairdocs.org/sdr/REXA2019061340817.md): Intercostal · cracked · May 24, 2019 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > INTERCOSTAL JUST AFT OF EXTERNAL POWER PLUG APPEARS TO BE CRACKED AT TOOLING HOLE, LOCATED JUST I/B AND AFT OF ACCESS DOOR 122BR OPENING. - EDGE BLENDED CRACKED AREA IN AFT INTERCOSTAL AT POWER PLUG IAW CRJ 200 SRM T.R 51-44 FOUND TO BE WITHIN LIMITS IAW CRJ 2 - [SDR REXA2019041700465](https://openairdocs.org/sdr/REXA2019041700465.md): Battery Pack · inoperative · Apr 17, 2019 · N8783E · Cndair CL6002B19 · Emergency Lighting > AFT FLOOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED PS4LF BATTERY AND CHARGER IAW AMM 33-51-05. OPS CHECK GOOD. - [SDR REXA2019010600011](https://openairdocs.org/sdr/REXA2019010600011.md): Wire Harness · damaged · Jan 6, 2019 · N8783E · Cndair CL6002B19 · Emergency Lighting > SUPPLEMENTAL INFORMATION. EMERGENCY FLOOR LIGHTING HAS 3 SECTIONS INOP FROM SEATS 6-8. FOUND EMERGENCY LIGHT CABLE ASSEMBLY IN FLOOR STRIP WITH BREAKS IN WIRES. INSTALLED NEW CABLE ASSY IAW AMM 33-51-01-400-808. REINSTALLED 3 FLOOR LIGHT SECTIONS IAW AMM 33-51 - [SDR REXA2019010200001](https://openairdocs.org/sdr/REXA2019010200001.md): Connector · loose · Jan 2, 2019 · N8783E · Cndair CL6002B19 · Light System Wiring > INSIDE EMERGENCY FLOOR LIGHTS CENTER SECTION IS INOPERATIVE. FOUND AND SECURED LOOSE CONNECTION AT SEAT 5C, D LOCATION IAW AMM 33-51-00. OPS CHECK GOOD. - [SDR REXA2018091400857](https://openairdocs.org/sdr/REXA2018091400857.md): Light · loose · Sep 13, 2018 · N8783E · Cndair CL6002B19 · Emergency Lighting > EMERGENCY FLOOR LIGHTNING INOP AT EMERGENCY EXIT ROW. FOUND EMER FLOOR LIGHT LOOSE. RESECURED IAW AMM 33-51-01. OP CHECK GOOD, OK FOR SVC. - [SDR REXA2018080620673](https://openairdocs.org/sdr/REXA2018080620673.md): Smoke Detector · false indication · Aug 2, 2018 · N8783E · Cndair CL6002B19 · Smoke Detection > HAD A SMOKE TOLIET CAUTION MESSAGE AND ALARM WENT IFF, FA WENT TO THE LAVATORY TO CHECK, NO SMOKE OR FUMES WERE FOUND. PERFORMED AN OPERATIONAL TEST OF AFT LAVATORY SMOKE DETECTOR IAW AMM 26-50-00, OPS TESTED GOOD. - [SDR REXA2018070300601](https://openairdocs.org/sdr/REXA2018070300601.md): Post · cracked · Jul 3, 2018 · N8783E · Cndair CL6002B19 · Fuselage Miscellaneous Structure > DURING COMPLIANCE OF T/C 53-160-635, NOTED VERT POST LBL 27.00 HAS A CRACK ON LWR IB FLANGE EXTENDING FROM EDGE UP TO AND PAST THE 1ST RIVET ENDING APPROX MID POINT BETWEEN 1ST AND 2ND RIVETS. REPAIRED VERT POST LBL 27.00 FS 409+128 IAW REO 601R-53-41-0056. TH - [SDR REXA2018060520435](https://openairdocs.org/sdr/REXA2018060520435.md): Connector · disconnected · Jun 2, 2018 · N8783E · Cndair CL6002B19 · Light System Wiring > FLOOR EMERGENCY LIGHTS INOPERATIVE. CONNECTED LIGHT AND OPS CHECKED GOOD IAW AMM 33-51-01. NO FURTHER DEFECTS NOTED. - [SDR REXA2018042760315](https://openairdocs.org/sdr/REXA2018042760315.md): Light · inoperative · Apr 26, 2018 · N8783E · Cndair CL6002B19 · Emergency Lighting > SECTION OF EMERGENCY LIGHTING BY SEAT 8DC WAS FOUND INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD. - [SDR REXA2018042040300](https://openairdocs.org/sdr/REXA2018042040300.md): Light · malfunctioned · Apr 19, 2018 · N8783E · Cndair CL6002B19 · Emergency Lighting > EMERGENCY FLOOR LIGHT IN THE MIDDLE OF THE CABIN IS NOT ILLUMINATING. PERFORMED AN OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CHECKED GOOD. - [SDR REXA2018040400246](https://openairdocs.org/sdr/REXA2018040400246.md): Seal · damaged · Apr 4, 2018 · N8783E · Cndair CL6002B19 · Galley Doors > GALLEY DOOR SEAL HAS VENT HOLES MISSING AND VENT HOLES IN WRONG LOCATION BEING BLOCKED IAW AMM 52-41-07. ADDED VENT HOLES AND RELOCATED BLOCKED HOLES IN THE GALLEY DOOR SEAL IAW AMM 52-41-07 - [SDR REXA2017120801231](https://openairdocs.org/sdr/REXA2017120801231.md): Light · unknown · Dec 8, 2017 · N8783E · Cndair CL6002B19 · Emergency Lighting > FLOOR LIGHTING STRIP INOP ROWS -7 AND WALL EXIT SIGN IS INOP PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHT PER CRJ 200 AMM 33-51-00. OPS CHECK GOOD, NO OTHER DEFECTS NOTED AT THIS TIME. - [SDR REXA2017111301162](https://openairdocs.org/sdr/REXA2017111301162.md): Battery Pack · inoperative · Nov 13, 2017 · N8783E · Cndair CL6002B19 · Emergency Equipment > DURING WAKE UP, CO PILOT EMERGENCY FLASHLIGHT WAS FOUND NOT BLINKING. BATTERY NOT CHARGING. REMOVED AND REPLACED THE BATTERY IN THE FLASHLIGHT IAW 25-61-00. OPS CHECKED GOOD. - [SDR REXA2017080400857](https://openairdocs.org/sdr/REXA2017080400857.md): Smoke Goggles · broken · Aug 4, 2017 · N8783E · Cndair CL6002B19 · Emergency Equipment > CAPTAIN`S SMOKE GOGGLES BROKEN. REMOVED AND REPLACED THE SMOKE GOGGLES IAW AMM 35-11-12 - [SDR REXA2017071700794](https://openairdocs.org/sdr/REXA2017071700794.md): Light · inoperative · Jul 17, 2017 · N8783E · Cndair CL6002B19 · Emergency Lighting > FLOOR LEVEL EXIT LIGHT NEXT TO LEFT EMERGENCY EXIT DOOR INOP. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-10. Next page: https://openairdocs.org/aircraft/N8783E/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 n_number = 'N8783E' AND registry_match = 'registration' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/aircraft/N8783E/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.