# Service difficulty reports: N619AE A list on [N619AE](https://openairdocs.org/aircraft/N619AE.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 4 · 165 reports - [SDR SIMA20221114001](https://openairdocs.org/sdr/SIMA20221114001.md): Cradle · broken · Nov 14, 2022 · N619AE · Emb EMB145LR · Emergency Equipment > FWD F/A'S EMERGENCY FLASHLIGHT HOLDER BROKEN-C/A-RAR F/A'S FLASHLIGHT BRACKET CLAMP FINGER IAW AMM 33-50-16. OPC GOOD. - [SDR SIMA20221025001](https://openairdocs.org/sdr/SIMA20221025001.md): Lamp · inoperative · Oct 25, 2022 · N619AE · Emb EMB145LR · Emergency Lighting > AFT CEILING LINING EMERGENCY LIGHT INOP-C/A-RAR AFT CEILING EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD. END. - [SDR SIMA20221021003](https://openairdocs.org/sdr/SIMA20221021003.md): Lamp · inoperative · Oct 21, 2022 · N619AE · Emb EMB145LR · Emergency Lighting > SERVICE DOOR EMERGENCY LIGHTS OUT-C/A-RAR EMERGENCY LIGHT LAMP AS IN EMB145 AMM 33-50-09. OPS CK GOOD - [SDR SIMA20220821002](https://openairdocs.org/sdr/SIMA20220821002.md): Lamp · inoperative · Aug 21, 2022 · N619AE · Emb EMB145LR · Emergency Lighting > ROW 12 CEILING EMERGENCY LIGHT INOP-C/A-RAR ROW 12 CEILING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD. END. - [SDR SIMA20220821001](https://openairdocs.org/sdr/SIMA20220821001.md): Lamp · inoperative · Aug 21, 2022 · N619AE · Emb EMB145LR · Emergency Lighting > SERVICE DOOR EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-09-000-801-A AND33-50-09-400-801-A. NO FIX. FOUND WIRES DISCONNECTED FROM SPLICE AND SPLICE DAMAGED. RAR SPLICE IAW SWPM 20-21-00. OPC GOOD. END. - [SDR SIMA20220714001](https://openairdocs.org/sdr/SIMA20220714001.md): Efis · inoperative · Jul 14, 2022 · N619AE · Emb ERJ170200LR · Flight Environment Data > DESCENDING THROUGH 8,000 FT AURAL WARNING CAUTION CAME, IT WAS THE LANDING GEAR TOO LOW TERRAIN, PULL UP. THE RA WAS SHOWING 30 FT. THE FAILURE LASTED FOR ABOUT 5 SECONDS. DID A RA TEST, THE CAT 2 AMBER ANNUNCIATOR DID NOT SHOW EITHER-C/A-MOVED RA ANTENNAS TO - [SDR SIMA20220625002](https://openairdocs.org/sdr/SIMA20220625002.md): Radio Altimeter · intermittent · Jun 25, 2022 · N619AE · Emb ERJ170200LR · Landing and Taxi Aids > DURING DESCENT THOUGH 6000 RADAR ALTIMETER INDICATED 25' AND RECIVED AUDIBLE "TOO LOW TERAIN AND PULL UP" REF AML PG. 4874576 ITEM 1 "TRANSFERRED TO NRWC 619-ABI-05021"MEL 34-8 AUTH# 060293DM-A -C/A-PERFORMED ERS-EM-34DF-088 PTA, 2.5 MILLIOHMS REQUIREMENT FROM - [SDR SIMA20220218002](https://openairdocs.org/sdr/SIMA20220218002.md): None · none · Feb 18, 2022 · N619AE · Emb EMB145LR · Emergency Lighting > RH OVERWNIG EMERGENCY LIGHT INOP-C/A-RAR RH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END. - [SDR SIMA20211016001](https://openairdocs.org/sdr/SIMA20211016001.md): None · none · Oct 16, 2021 · N619AE · Emb EMB145LR · Emergency Lighting > OVERWING EMERGENCY EXIT FORWARD CEILING LOCATOR LIGHT INOP-C/A-RAR NO. 6 EMERGENCY LIGHT AC/DC INVERTER IAW EMB 145 AMM 33-50-11. OPC GOOD. - [SDR SIMA20210719002](https://openairdocs.org/sdr/SIMA20210719002.md): Light · inoperative · Jul 19, 2021 · N619AE · Emb EMB145LR · Emergency Lighting > DURING PS-2 CHECK FOUND RH CENTER FAIRING EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR RH CENTER FAIRING EXTERIOR EMERGENCY LIGHT IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. - [SDR SIMA20210714002](https://openairdocs.org/sdr/SIMA20210714002.md): Light · broken · Jul 14, 2021 · N619AE · Emb EMB145LR · Emergency Lighting > EMERGENCY FLOOR LIGHT AT ROW 8/9 WIRE BROKEN OFF-C/A-REPLACED EMERGENCY FLOOR LIGHT STRIP AT ROW 8/9 IAW EMB 145MM 33-50-12. - [SDR SIMA20210709003](https://openairdocs.org/sdr/SIMA20210709003.md): Clamp · broken · Jul 9, 2021 · N619AE · Emb EMB145LR · Emergency Equipment > FA EMERGENCY FLASHLIGHT MOUNT HAS A BROKEN CLAMP-C/A-RAR FWD FA EMERGENCY FLASHLIGHT IAW EMB145 AMM 33-50-16. OPC GOOD. - [SDR SIMA20210104001](https://openairdocs.org/sdr/SIMA20210104001.md): Flashlight Assy · broken · Jan 4, 2021 · N619AE · Emb EMB145LR · Emergency Equipment > FA EMERGENCY FLASHLIGHT CLIP AND FLASHLIGHT BROKEN. MEL 25-53, AUTH 010001-C, LGPG 4714201, ITEM 1. C/A: REMOVED AND REPLACED F/A EMERGENCY FLASHLIGHT ASSEMBLY, IAW EMB 145 CMM 25-60-14. OPERATIONS CHECKED GOOD. MEL NR 25-53 RESTORED. - [SDR SIMA20201204003](https://openairdocs.org/sdr/SIMA20201204003.md): Latch · broken · Dec 4, 2020 · N619AE · Emb EMB145LR · Emergency Equipment > F/A EMERGENCY FLASHLIGHT HOLDER FWD CABIN HAS LATCH BROKE. C/A: R & R FWD EMERGENCY FLASHLIGHT, IAW EMB 145 AMM 33-50-16. OPERATIONS CHECK GOOD. - [SDR SIMA202009076004](https://openairdocs.org/sdr/SIMA202009076004.md): Connector · loose · Sep 6, 2020 · N619AE · Emb EMB145LR · Doppler System > APROX 15,000 MSL - RECEIVED ARUAL TO LOW TERRAIN WARNING BRIEFLY APPROXIMATELY 4,000 MSL. RECEIVED AURAL TOO LOW TERRAIN AND LANDING GEAR WARNING BRIEFLY. TRANSFERRED TO NRWC 619-ABI-03950 J. WILLIAMS 507866. C/A FOUND LT AND RT RA ANTENNA CONNECTIONS VERY - [SDR SIMA2020083129006](https://openairdocs.org/sdr/SIMA2020083129006.md): Drag Angle · cracked · Aug 29, 2020 · N619AE · Emb EMB145LR · Vertical Stabilizer, Attach Fittings > CRACK ON RH FWD VERTICAL TO FUSELAGE DRAG ANGLE NEAR AFT END IN RADIUS.-C/A-REMOVED AND REPLACED RH FWD VERTICAL TO FUSELAGE DRAG ANGLE IAW EMB 145 SRM 51-40-02. - [SDR SIMA2020083129005](https://openairdocs.org/sdr/SIMA2020083129005.md): Skin · deformed · Aug 29, 2020 · N619AE · Emb EMB145LR · Fuselage Main, Plate/Skin > SKIN DEFORMATION LOCATED AT FRAME 23 STRINGERS 16R ? 17R.-C/A-SKIN DEFORMATION LOCATED AT FRAME 23 STRINGERS 16R ? 17R. FOUND STRINGER 17R AT FR 23 TO BE BENT. PERFORMED STRINGER REPAIR IAW EMB 145 SRM 53-00-03-RE. - [SDR SIMA20200824005](https://openairdocs.org/sdr/SIMA20200824005.md): Rib · cracked · Aug 24, 2020 · N619AE · Emb EMB145LR · Wing, Rib/Bulkhead > LEFT WING RIB 21 INSIDE PANEL 551CB IS CRACKED. REPAIRED THE LT WING RIB 21 IAW SRM 57-20-07RE ITEM 4. - [SDR SIMA20200824002](https://openairdocs.org/sdr/SIMA20200824002.md): Nut Plate · corroded · Aug 24, 2020 · N619AE · Emb EMB145LR · Cargo/Baggage Doors > CARGO DOOR UPPER NUT PLATE HOLES HAVE CORROSION 5 EA. REMOVED AND REPLACED CARGO DOOR UPPER NUT PLATE PROFILE IAW SRM 51-40-02. - [SDR SIMA20200824001](https://openairdocs.org/sdr/SIMA20200824001.md): Web · chafed · Aug 24, 2020 · N619AE · Emb EMB145LR · Cargo/Baggage Doors > CARGO DOOR LOWER FWD WEBBING CHAFED AT FASTENER. REPAIRED CARGO DOOR LOWER FWD WEBBING IAW SRM 52-30-01RE AND ETN-EM-52-043. - [SDR SIMA202008242003](https://openairdocs.org/sdr/SIMA202008242003.md): Nut Plate · corroded · Aug 22, 2020 · N619AE · Emb EMB145LR · Cargo/Baggage Doors > CARGO DOOR LOWER NUT PLATE HOLES HAVE CORROSION 7 EA.-C/A-REMOVED AND REPLACED CARGO DOOR LOWER NUT PLATE PROFILE IAW EMB 145 SRM 51-40-02. - [SDR SIMA202008210001](https://openairdocs.org/sdr/SIMA202008210001.md): Yoke · cracked · Aug 20, 2020 · N619AE · Emb EMB145LR · Engine Mount Section > RH ENGINE FWD LOWER YOKE CRACKED. REMOVED AND REPLACED RH ENGINE FWD LOWER YOKE IAW ERS-EM-54MR-698. - [SDR SIMA202008109002](https://openairdocs.org/sdr/SIMA202008109002.md): Wire · damaged · Aug 9, 2020 · N619AE · Emb EMB145LR · Light System Wiring > EMERGENCY LIGHT STRIP 8 HAS WIRE INSULATION PULLED OUT OF HOUSING ON BOTH WIRES. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. - [SDR SIMA2020082104002](https://openairdocs.org/sdr/SIMA2020082104002.md): Skin · damaged · Aug 4, 2020 · N619AE · Emb EMB145LR · Elevator, Plate/Skin > LEFT ELEVATOR TRAIL EDGE UPPER SKIN HAS HOLE. PERFORMED A REPAIR ON THE LT ELEVATOR TRAIL EDGE IAW ERS-EM-55MR-854. - [SDR SIMA20200729004](https://openairdocs.org/sdr/SIMA20200729004.md): Battery Pack · inoperative · Jul 29, 2020 · N619AE · Emb EMB145LR · Emergency Lighting > NR 4 EMERGENCY BATTERY INOP. C/A COMPLETE: R & R NR 4 EMERGENCY BATTERY AND BATTERY POWER SUPPLY, IAW EMB 145 AMM 33-50-04 ETN-EM-20-040 BONDING TEST GOOD. EMERGENCY LIGHTING SYSTEM, OPS CHECK GOOD MILLIOHM METER NR 6488. - [SDR SIMA20200729003](https://openairdocs.org/sdr/SIMA20200729003.md): Light · cracked · Jul 29, 2020 · N619AE · Emb EMB145LR · Emergency Lighting > LT EMERGENCY LIGHT STRIP PANELS AT POSITIONS 2, 3, 5, AND 8 ARE CRACKED/BROKEN. C/A COMPLETE: REMOVED AND REPLACED LT EMERGENCY LIGHT STRIP COVER PANELS AT POSITIONS 2,3,5, AND 8, IAW EMB-145 AMM 33-50-12. SEE BOW 346487 FOR INSTALL ONTO AIRCRAFT. - [SDR SIMA20200729002](https://openairdocs.org/sdr/SIMA20200729002.md): Battery Pack · not reported · Jul 29, 2020 · N619AE · Emb EMB145LR · Emergency Lighting > A3265 OPS A. REMOVE AND REPLACE EMERGENCY LIGHTING BATTERY ASSY/BATTERY CHARGER EMB WC 33-700-19 CRJ WC 33-002 ETN-EM-25-385 PN 2013-1A SN 10484 POS 3. C/A COMPLETE: REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY ASSY/ BATTERY CHARGER PN 2013-1A SN 104848 P - [SDR SIMA202006291004](https://openairdocs.org/sdr/SIMA202006291004.md): Outflow Valve · failed · Jun 21, 2020 · N619AE · Emb EMB145LR · Pressure Regulator/Outflow Valve > CABIN ALT REACHED 9600FT @ AT FL190 AFTER DESCENDING TO 10000FT CABIN SLOWLY REPRESSURIZED TO 400 FT (DELTA)P 4.4 NORMAL FOR THAT ALTITUDE-C/A-FOUND PNEUMATIC OUTFLOW VALVE STICKING, REPLACED AND REMOVED P.O.V. IAW AMM 21-31-04. PERFORMED FUNCTIONAL CHECK IAW - [SDR SIMA202006198002](https://openairdocs.org/sdr/SIMA202006198002.md): Support · damaged · Jun 18, 2020 · N619AE · Emb EMB145LR · Passenger/Crew Doors > SUPPLEMENTAL MAIN PAX ENTRY DOOR VERY HARD TO OPEN.-C/A-WHILE T/S HARD TO OPEN AND INSPECTION SUPPORT ASSY BOLTS IAW ETN-EM-52-052 FOUND DAMAGE TO THE BEARING SUPPORT AND LOCKING SHAFT MIGRATING. REF ITEM #3 THIS LOG PAGE FOR DISCREPANCIES. REMOVED AND REPLACE - [SDR SIMA202006176001](https://openairdocs.org/sdr/SIMA202006176001.md): Lock · lack of lube · Jun 16, 2020 · N619AE · Emb EMB145LR · Passenger/Crew Doors > FA REPORTS ENTRY DOOR IS EXTREMELY HARD TO UNLOCK + WILL UNLOCK HALFWAY THEN GOT STUCK. ONCE UNLOCKED IT IS HARD TO PUSH OPEN.-C/A-LUBRICATED PAX DOOR ROLLERS IAW AMM 53-21-03. NO DEFECTS NOTED. - [SDR SIMA202002110001](https://openairdocs.org/sdr/SIMA202002110001.md): Drive Unit · damaged · Feb 10, 2020 · N619AE · Emb EMB145LR · Trailing Edge Flap Control System > FLAP FAIL UPON ACCD ALT ON TAKEOFF-C/A-T/S FLAP FAIL MSG IAW FIM 27-51-00-810-801-A REMOVED AND REPLACED FPDU IAW EMB 145 AMM 27-53-04 NO FIX REMOVED AND REPLACED FECU IAW EMB 145 AMM 27-53-02 OPS CHECK GOOD IAW EMB 145 AMM 27-53-00-700-802-A NO FURTHER DEF - [SDR SIMA2020020411008](https://openairdocs.org/sdr/SIMA2020020411008.md): Charger · failed · Nov 11, 2019 · N619AE · Emb EMB145LR · Emergency Lighting > GALLEY EMERGENCY LIGHTS NOT PASSING FUNCTIONAL CHECK-C/A-REMOVED AND REOLACED NUMBER 2 EMERGENCY BATTERY POWER SUPPLY ASSY IAW EMB AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 67906 - [SDR SIMA202002061108](https://openairdocs.org/sdr/SIMA202002061108.md): Wing · damaged · Nov 10, 2019 · N619AE · Emb EMB145LR · Wing Main, Frame Structure > WX-DMG / A/C LANDED SLID OFF RWY INTO TERRAIN. NO INJ TO CREW/PAX. ALL PAX TRANSPORTED TO TERMINAL BY BUS. EMERGENCY DECLARED.-C/A-PENDING CORRECTIVE ACTIONS. REINSTALLED RH WING SPEED BRAKE ACTUATOR IAW STEPS 3A THRU/INCLUDING 3J(6) OF AMM 27-62-02-400-801A. - [SDR SIMA2019100198011](https://openairdocs.org/sdr/SIMA2019100198011.md): Lamp · inoperative · Sep 28, 2019 · N619AE · Emb EMB145LR · Emergency Lighting > ROW 17 AISLE EMERGENCY LIGHT INOPERATIVE. R & R ROW 17 AISLE EMERGENCY LIGHT LAMP IAW AMM 33-50-08. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED. - [SDR SIMA20190711003](https://openairdocs.org/sdr/SIMA20190711003.md): Warning System · false activation · Jul 11, 2019 · N619AE · Emb EMB145LR · Pneumatic Indicating System > BLD 2 LEAK WARNING MSG. C/A-PERFORMED INSPECTION AND LEAK CHECK OF BLEED 2 AIR SYSTEM AS PER AMM 36-11-09. WITH ENGINE RUNNING FOR 25 MINS. NO LEAKS OR FAULTS NOTED. - [SDR SIMA20190320006](https://openairdocs.org/sdr/SIMA20190320006.md): Light · inoperative · Mar 20, 2019 · N619AE · Emb EMB145LR · Emergency Lighting > MAIN-DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED MAIN-DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-06-000-801-A AND AMM 33-50-06-400-801-A. OPS CHECK GOOD. NO MORE DEFECTS NOTED AT THIS TIME. END. - [SDR SIMA20190205003](https://openairdocs.org/sdr/SIMA20190205003.md): Light · inoperative · Feb 5, 2019 · N619AE · Emb EMB145LR · Emergency Lighting > FWD CEILING EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT IAW AMM 33-50-08. OPC GOOD. - [SDR SIMA20180930005](https://openairdocs.org/sdr/SIMA20180930005.md): Hinge Fitting · worn · Sep 30, 2018 · N619AE · Emb EMB145LR · Ailerons > RIGHT AILERON OUTBOARD HINGE FITTING HAS A MIGRATING BUSHING. REMOVED AND REPLACED RT AILERON OB HINGE FITTING/BUSHING ASSY IAW EO EM-27MR-112. - [SDR SIMA20180926001](https://openairdocs.org/sdr/SIMA20180926001.md): Structure · unknown · Sep 26, 2018 · N619AE · Emb EMB145LR · Fuselage Main, Structure > EM-52MR-236 PTB COCKPIT UNDERFLOOR ACCESS HATCH FRAME REPAIR-C/A-C/W EO# EM-52MR-236 PART B - [SDR RAIA2018080620001](https://openairdocs.org/sdr/RAIA2018080620001.md): Bracket · loose · Aug 2, 2018 · N619AE · Emb EMB145LR · Landing Gear Position and Warning > LDG AIR/GND FAILED, INSPECTED AND FOUND A LOOSE BRACKET HOLDING THE WOW SWITCH ON THE LT AFT LANDING GEAR, PERFORMED AN OPS CHECK OF ALL 5 WOW SWITCHES INDIVIDUALY. PERFORMED AIR GROUND SYSTEM SIMULATION TEST THREE TIMES, OPS CHECKED GOOD, NO MESSAGE ON EI - [SDR RAIA201803310002](https://openairdocs.org/sdr/RAIA201803310002.md): Warning Message · illuminated · Mar 31, 2018 · N619AE · Emb EMB145LR · Cabin Cooling System > NR 2 PACK OVERLOAD. R & R THE SLEEVE, OPS CHECKED GOOD. - [SDR RAIA2018042610001](https://openairdocs.org/sdr/RAIA2018042610001.md): Shear Tie · corroded · Mar 30, 2018 · N619AE · Emb EMB145LR · Fuselage Internal Mounting Structure > FRAME 65 SHEAR TIE CORRODED ON THE LOWER END BY CARGO DOOR SILL. REPAIRED THE SHEAR TIE. - [SDR RAIA201801310002](https://openairdocs.org/sdr/RAIA201801310002.md): Clamp · loose · Jan 31, 2018 · N619AE · Emb EMB145LR · Pneumatic Distribution System > BLEED 2 LEAK ON CLIMB OUT FOUND HIGH STAGE VLV CLAMP LOOSE AND TIGHTENED. FOUND BLEED VALVE NR 2 CLAMP LOOSE AND TIGHTENED. RAN THE LEAK CHECK AT 90%. NO LEAKS NOTED AT THIS TIME. - [SDR RAIA201801300002](https://openairdocs.org/sdr/RAIA201801300002.md): Sensor · loose · Jan 30, 2018 · N619AE · Emb EMB145LR · Pneumatic Distribution System > NR 2 BLEED LEAK IN FLT, WHILE CLIMBING THROUGH 13,000 FEET. QRH PERFORMED, NO CHANGE. SECURED A LOOSE TEMP SENSOR ON THE DUCT FORWARD OF THE NR 2 PRE COOLER. OPS CHECKED GOOD. - [SDR RAIA201801280001](https://openairdocs.org/sdr/RAIA201801280001.md): O-Ring · leaking · Jan 28, 2018 · N619AE · Emb EMB145LR · Pneumatic Distribution System > NR 2 BLEED LEAK WARNING IN FLIGHT. FOUND A BROKEN O-RING AT DUCT JOINT 14. R & R O-RING. OPS CHECKED GOOD. - [SDR RAIA201801220001](https://openairdocs.org/sdr/RAIA201801220001.md): Smoke Detector · false activation · Jan 22, 2018 · N619AE · Emb EMB145LR · Smoke Detection > EICAS WARNING BAGG SMOKE DURING PUSH. BAGGAGE FIRE EXT BUTTON PRESSED. REMOVED AND REPLACED FWD CARGO BAY SMOKE DETECTOR. OPS CHECK GOOD. - [SDR RAIA201801050002](https://openairdocs.org/sdr/RAIA201801050002.md): Skin · gouged · Jan 5, 2018 · N619AE · Emb EMB145LR · Fuselage Main, Plate/Skin > SKIN REPAIR DOUBLER AT FRAME 75, STRINGER 2R GOUGED. REPAIRED THE SKIN DOUBLER. - [SDR RAIA201712260003](https://openairdocs.org/sdr/RAIA201712260003.md): Frame · cracked · Dec 26, 2017 · N619AE · Emb EMB145LR · Fuselage Main, Frame > FRAME 73 CRACKED JUST BELOW THE RT AFT FLOOR SILL. R & R THE FRAME LOWER SECTION. - [SDR RAIA201712060002](https://openairdocs.org/sdr/RAIA201712060002.md): Frame · cracked · Dec 26, 2017 · N619AE · Emb EMB145LR · Fuselage Main, Frame > FRAME 66 CRACKED AT STRINGER 16R. REPAIRED THE FRAME. - [SDR RAIA201712260001](https://openairdocs.org/sdr/RAIA201712260001.md): Shear Tie · corroded · Dec 26, 2017 · N619AE · Emb EMB145LR · Fuselage Internal Mounting Structure > FRAME 65 SHEAR TIE CORRODED IN THE CARGO DOOR CUTOUT, LOWER CORNER. REPAIRED THE SHEAR TIE. Next page: https://openairdocs.org/aircraft/N619AE/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 = 'N619AE' AND registry_match = 'registration' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/aircraft/N619AE/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.