# Service difficulty reports: N902BC A list on [N902BC](https://openairdocs.org/aircraft/N902BC.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 · 172 reports - [SDR HNAA2026060200465](https://openairdocs.org/sdr/HNAA2026060200465.md): Seat Track · corroded · May 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > F123491 RH OTBD SEAT TRACK #1 HAS CORROSION ON MULIPLE SPOTS. REMOVED AND REPLACED RH OTBD SEAT TRACK #1 IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200470](https://openairdocs.org/sdr/HNAA2026060200470.md): Seat Track · corroded · May 2, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > F124214 LH OTBD #6 SEAT TRACK HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED LH OTBD #6 SEAT TRACK IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200471](https://openairdocs.org/sdr/HNAA2026060200471.md): Partition · gouged · Apr 30, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Structure > LH COCKPIT PARTITION LOWER PIN HOLE LOCATION ON INTERNAL FUSELAGE STRUCTURE IS GOUGED. ACCOMPLISHED PERMANENT REPAIR TO LH COCKPIT PARTITION LOWER PIN HOLE LOCATION ON NTERNAL FUSELAGE GOUGE IAW EMB 145 SRM 53-21-02RE, ITEM 4, FIG 204 AND EO1-53-26-0245. - [SDR HNAA2026060200473](https://openairdocs.org/sdr/HNAA2026060200473.md): Floorbeam · damaged · Apr 30, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Floor Beam > CENTER FLOOR BEAM GUSSET HAS TWO ELONGATED HOLES AT NUTPLATE ATTACHMENT BETWEEN FRAMES 70-71. REMOVED AND REPLACED CARGO. CENTER FLOOR BEAM GUSEET AND PERFORMED REPAIR ON CENTER FLOOR BEAM BETWEEN FRAMES 70-71 IAW EMB 145 SRM 51-20-03, 51-40-02, EMB 145 ETD2 - [SDR HNAA2026060200469](https://openairdocs.org/sdr/HNAA2026060200469.md): Beam · corroded · Apr 29, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Structure > CORROSION IN COCKPIT ON PILOTS INBD BEAM GUSSET. FABRICATED AND INSTALLED BOTH DOUBLERS TO REPAIR COCKPIT PILOTS INBD BEAM GUSSET. PAINTED BOTH DOUBLER ON PILOTS OUTBD AND INBOARD SEAT TRACK GUSSET IAW EMB 145 CPM 51-21-06 AND PDT BULLETIN. REPAIR OF THE COCK - [SDR HNAA2026060200468](https://openairdocs.org/sdr/HNAA2026060200468.md): Beam · corroded · Apr 29, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Structure > CORROSION IN COCKPIT ON PILOTS OTBD BEAM GUSSET. UPON FURTHER INVESTIGATION FOUND REMAINING THICKNESS AT BLENDED AREAS IN COCKPIT ON PILOTS OTBD BEAM GUSSET TO BE WITHIN NON-SIGNIFICANT DAMAGE IAW EMB 145 SRM 51-10-05. - [SDR HNAA2026060200472](https://openairdocs.org/sdr/HNAA2026060200472.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > LH CENTER AISLE OMEGA BEAM HAS CORROSION BETWEEN FRAME 58 AND FRAME 59. INSTALLED FABRICATED DOUBLER AND L EXTERNAL DOUBLER REPAIR ON LH CENTER AISLE OMEGA BEAM BETWEEN FR 58/59 IAW EMB 145 SRM 53-30-10 RE ITEM 5 FIGURE 204 AND PIEDMONT EO1-53-26-0236. - [SDR HNAA2026060200467](https://openairdocs.org/sdr/HNAA2026060200467.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > LH #2 FLOORSILL HAS CORROSION ON MULTIPLE SPOTS. RAR LH #2 FLOOR SILL IAW EMB 145 SRM 51-40-02. - [SDR HNAA2026060200466](https://openairdocs.org/sdr/HNAA2026060200466.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > LEFT OTBD SEAT TRACK #1 HAS CORROSION ON MULTIPLE SPOTS. RAR LH OTBD SEAT TRACK #1 IAW AMM 51-01-06. - [SDR HNAA2026060200464](https://openairdocs.org/sdr/HNAA2026060200464.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > RIGHT CENTER AISLE SEAT TRACK NR 1 HAS CORROSION ON MULIPLE SPOTS. REMOVED AND REPLACED RH CENTER AISLE SEAT TRACK NR 1 IAW AMM 53-01-06. - [SDR HNAA2026060200463](https://openairdocs.org/sdr/HNAA2026060200463.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > LEFT CENTER AISLE SEAT TRACK NR 2 HAS CORROSION ON MULIPLE SPOTS. R & R LT CENTER AISLE SEAT TRACK NR 2 IAW AMM 53-01-06. - [SDR HNAA2026060200462](https://openairdocs.org/sdr/HNAA2026060200462.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > LEFT OTBD SEAT TRACK NR 2 HAS CORROSION ON MULIPLE SPOTS. REMOVED AND REPLACED LT OTBD SEAT TRACK NR 2 IAW AMM 53-01-06. - [SDR HNAA2026060200461](https://openairdocs.org/sdr/HNAA2026060200461.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > RIGHT FLOOR SILL NR 2 HAS CORROSION ON MULTIPLE SPOTS. REMOVED RT FLOOR SILL NR 2 IAW SRM 51-40-02 BEGAN INSTALLATION OF RT FLOOR SILL NR 2 IAW SRM 51-40-02 R & R RT FLOOR SILL NR 2 IAW SRM 51-40-02. PREPPED PRIMED AND PAINTED RIVETS IAW CPM 51-21-06, CPM 5 - [SDR HNAA2026060200460](https://openairdocs.org/sdr/HNAA2026060200460.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > RIGHT CENTER AISLE SEAT TRACK NR 2 HAS CORROSION ON MULTIPLE SPOTS. RT CENTER AISLE SEAT TRACK #2 WAS REMOVED AND REPLACED IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200459](https://openairdocs.org/sdr/HNAA2026060200459.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > LH CENTER AISLE SEAT TRACK #3 HAS CORROSION ON MULTIPLE SPOTS. R & R LH CENTER AISLE SEAT TRACK #3 IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200458](https://openairdocs.org/sdr/HNAA2026060200458.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > F123481 LH #3 FLOORSILL HAS CORROSION ON MULTIPLE SPOTS. RAR LH #3 FLOORSILL IAW EMB 145 SRM 51-40-02 - [SDR HNAA2026060200457](https://openairdocs.org/sdr/HNAA2026060200457.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > RT NR 3 FLOOR SILL HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED RT NR 3 FLOOR SILL IAW EMB 145 SRM 51-40-02. - [SDR HNAA2026060200456](https://openairdocs.org/sdr/HNAA2026060200456.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > LH #4 FLOOR SILL HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED LH #4 FLOOR SILL IAW EMB 145 SRM 51-40-02 - [SDR HNAA2026060200455](https://openairdocs.org/sdr/HNAA2026060200455.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > F123478 RH CENTER AISLE SEAT TRACK #3 HAS CORROSION ON MULTIPLE SPOTS, REMOVED AND REPLACED RH CENTER AISLE SEAT TRACK #3 IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200454](https://openairdocs.org/sdr/HNAA2026060200454.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > RH CENTER AISLE #4 SEAT TRACK HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED RH CENTER AISLE #4 SEAT TRACK IAW EMB 145 AMM 53-01-06 TQ. EASI # 7336 - [SDR HNAA2026060200453](https://openairdocs.org/sdr/HNAA2026060200453.md): Seat Track · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage, Seat/Cargo Attach Fittings > LEFT CENTER AISLE NR 5 SEAT TRACK HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED LH CENTER AISLE 5 SEAT TRACK IAW EMB 145 AMM 53-01-06. - [SDR HNAA2026060200452](https://openairdocs.org/sdr/HNAA2026060200452.md): Floor Support · corroded · Apr 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > RT FLOOR SILL NR 5 HAS CORROSION ON MULTIPLE SPOTS. REMOVED AND REPLACED RT FLOOR SILL NR 5 IAW SRM 51-40-02. - [SDR HNAA2026060200451](https://openairdocs.org/sdr/HNAA2026060200451.md): Door Sill · corroded · Apr 24, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Structure > F122826 CORROSION ON CARGO DOOR CUT-OUT FLOOR SILL. REMOVED AND REPLACE CARGO DOOR CUT OUT FLOOR SILL IAW EMB 145 SRM 51-40-02. - [SDR HNAA2026060200450](https://openairdocs.org/sdr/HNAA2026060200450.md): Frame · corroded · Apr 24, 2026 · N902BC · Emb EMB145LR · Fuselage Main, Frame > F122812 CORROSION IN CARGO COMPARTMENT ON FRAME 61 WEBBING AT STRINGER 16R. REMOVED AND REPLACED WEBBING PANEL AT FRAME 61 (BANANA PANEL) IAW EMB 145 SRM 51-40-02 - [SDR HNAA2026060200449](https://openairdocs.org/sdr/HNAA2026060200449.md): Floor Support · corroded · Apr 24, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > CORROSION IN CARGO COMPARTMENT ON LH FWD FLOOR SILL. REMOVED AND REPLACED LH FWD CARGO COMPARTMENT FLOOR SILL IAW SRM 51-40-02. - [SDR HNAA2026060200474](https://openairdocs.org/sdr/HNAA2026060200474.md): Skin · punctured · Apr 22, 2026 · N902BC · Emb EMB145LR · Rudder, Plate/Skin > RUDDER 2 LH SIDE SKIN LOWER AFT CORNER HAS 2 PUNCTURES. INSTALLED REPAIR DOUBLER/ FILLER ON RUDDER 2 LH SIDE SKIN LOWER AFT CORNER IAW EMBRAER ETD2026-145-008190 AND PIEDMONT EO1-55-26-0229. - [SDR HNAA2026040300255](https://openairdocs.org/sdr/HNAA2026040300255.md): Engine · odor · Apr 3, 2026 · N902BC · Emb EMB145LR · Air Distribution System > BURNING RUBBER SMELL IN FLIGHT DECK AT ABOUT 1000 TO 2000 FT. BORESCOPED COMPRESSOR FLOWPATH EXT AREA ENG 1. FOUND OIL ON BOLT HEADS FOR CARBON SEAL #4. ENGINE CHANGE RECOMMENDED WITHIN 100FLT HOURS PER ROLLS ROYCE MM 72-30-00-200-803 SUBTASK 3A. FACT 06APR - [SDR HNAA2026040300252](https://openairdocs.org/sdr/HNAA2026040300252.md): Unknown · odor · Apr 2, 2026 · N902BC · Emb EMB145LR · Air Distribution System > ON T/O ROLL WOODSY SMOKE ODOR IN FLT DECK, IN CLIMB ODOR GOT STRONGER W/ FA REPORTING ODOR AND VISABLE SMOKE AROUND PAX DOOR. RTF DONED CREW O2 MASKS TURNED OFF GASPER AND RECIRC FANS. ODOR/SMOKE DISAPPATED ON LANDING. OPERATED PACK 1 AND 2 ON BOTH APU BLEED - [SDR HNAA2026060200448](https://openairdocs.org/sdr/HNAA2026060200448.md): Support · corroded · Mar 28, 2026 · N902BC · Emb EMB145LR · Fuselage Miscellaneous Structure > GALLEY RT AFT SILL HAS MULTIPLE AREAS OF CORROSION. R & R GALLEY RH AFT SILL IAW SRM 51-40-02. - [SDR HNAA2026021900138](https://openairdocs.org/sdr/HNAA2026021900138.md): Unknown · odor · Feb 19, 2026 · N902BC · Emb EMB145LR · Air Distribution System > ON CLIMB FLIGHT DECK SMELLED OF BURNING RUBBER DISAPATED AT 5000 FEET AND DID NOT REOCCUR. CHECKED PACK 1, 2, & FWD AVIONICS BAY, NO ODOR FOUND. RAN ENG 1 TWICE, COUND NOT DUPLICATE SMELL. A/C OK FOR SERVICE AT THIS TIME. - [SDR HNAA2025071700469](https://openairdocs.org/sdr/HNAA2025071700469.md): Bleed Valve · abnormal · Jul 16, 2025 · N902BC · Emb EMB145LR · Compressor Bleed Valve > BLD 1 LEAK WARNING MESSAGE APPEARED DURING CLIMB. AFTER RUNNING QRH INSCRIPTION MESSAGE WENT AWAY. REMOVED AND REPLACED PNEUMATIC CROSS BLEED VALVE IRT AMM 36-10-01-000/400-801-A OPS CHECK GOOD OK FOR SERVICE - [SDR HNAA2025060900408](https://openairdocs.org/sdr/HNAA2025060900408.md): Precooler · cracked · Jun 6, 2025 · N902BC · Emb EMB145LR · Pneumatic Indicating System > ON CLIMB OUT OF PHL BLEED 2 LEAK WARNING MESSAGE PRESENTED. FOUND CRACK IN #2 ENG PRECOOLER R+R #2 ENG PRECOOLER IAW AMM 36-11-04. OPS CHECK GOOD - [SDR HNAA2025051200308](https://openairdocs.org/sdr/HNAA2025051200308.md): Actuator · cracked · May 11, 2025 · N902BC · Emb EMB145LR · Drag Control Actuator > HYD 2 FAIL MSG ON EICAS DFRL 11MAY25 15:46 CLT INSPECTED AND FOUND #1 SPEED BRAKE ACTUATOR CRACKED (SS) FACT 11MAY25 22:51 CLT R&R L/H SPEED BRAKE ACTUATOR. LEAK CHECK GOOD. OPS CHECK GOOD IAW AMM 27-62-02. - [SDR HNAA2023080200259](https://openairdocs.org/sdr/HNAA2023080200259.md): Unknown · unknown · Aug 2, 2023 · N902BC · Emb EMB145LR · Stabilizer Position Indicating > IN FLIGHT PTRIM BACK UP INOP DISPLAYED ON EICAS FACT 29JUL23 18:31 PHL PDPU THE AC/ PERFORMED OPS IAW AMM 27-40-00-700-802-A. OPS CHECK GOOD, OK FOR SERVICE - [SDR SIMA20230417001](https://openairdocs.org/sdr/SIMA20230417001.md): Unknown · unknown · Apr 17, 2023 · N902BC · Emb EMB145LR · Exterior Lighting > DURING PS2 CHECK FOUND LH EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR EMERGENCY LIGHT ASSY IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME. - [SDR SIMA20230413001](https://openairdocs.org/sdr/SIMA20230413001.md): Unknown · unknown · Apr 13, 2023 · N902BC · Emb EMB145LR · Emergency Lighting > LH EXTERNAL OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH EXTERNAL OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-10.OPS CHECK GOOD - [SDR SIMA20230411001](https://openairdocs.org/sdr/SIMA20230411001.md): Unknown · unknown · Apr 11, 2023 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH EXTERNAL OVERWING EMERGENCY LIGHT BULB IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A OPC GOOD END - [SDR SIMA20230403002](https://openairdocs.org/sdr/SIMA20230403002.md): Lamp · inoperative · Apr 3, 2023 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVER WING EMERGENCY LIGHT INOP.-C/A-FOUND H OVERWING EMERGENCY LIGHT LAMP BURNT OUT RAR LIGHT LAMP ON L/H OVERWING EMERGENCY LIGHT ASSEMBLY IAW EMB-145 AMM 33-50-10. OPS CHECK GOOD - [SDR SIMA20230309002](https://openairdocs.org/sdr/SIMA20230309002.md): None · none · Mar 9, 2023 · N902BC · Emb EMB145LR · Trailing Edge Flap Control System > FLAP FAIL CAUTION ON EICAS FLAP 45 INDICATION ON THE EICAS AND RMU DECLARED EMERGENCY. THE FAIL MESSAGE CAME ON AFTER SELECTING FLAPS 45 AND INDICATING FLAPS 45-C/A-DOWNLOADED CMC AND FOUND FLAP DRIVE TX FAIL MESSAGE ON CMC T/S FLAP DRIVE TX FAIL IAW FIM 27-51 - [SDR SIMA20230308001](https://openairdocs.org/sdr/SIMA20230308001.md): Lamp · inoperative · Mar 8, 2023 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH WING EMERGENCY LIGHT LAMP IAW AMM 33-50-07-000-801-A AND 33-50-07-400-801-A. OPS CHECK GOOD. END. - [SDR SIMA20221110001](https://openairdocs.org/sdr/SIMA20221110001.md): Roller · lack of lube · Nov 10, 2022 · N902BC · Emb EMB145LR · Passenger/Crew Doors > MAIN CABIN DOOR HARD TO OPEN-C/A-CLEANED AND LUBED MAIN DOOR FRAME ROLLERS IAW EMB 145 AMM 53-21-02. OPC GOOD - [SDR SIMA20221017001](https://openairdocs.org/sdr/SIMA20221017001.md): None · unserviceable · Oct 17, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > FIRST 3 CABIN FLOOR EMERGENCY LIGHTS INOP.-C/A-RAR BATTERY CHARGER ASSY (2) AS PER EMB 145 AMM 33-50-04 OPS CHECK GOOD - [SDR SIMA20220919001](https://openairdocs.org/sdr/SIMA20220919001.md): Lamp · inoperative · Sep 19, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH OVERWING EMERGENCY LIGHT LAMP IAW AMM 35-50-10 - [SDR SIMA20220626002](https://openairdocs.org/sdr/SIMA20220626002.md): Duct · loose · Jun 26, 2022 · N902BC · Emb EMB145LR · Air Distribution System > COCKPIT HAS WEIRD FUME SMELL.-C/A-WHEN TROUBLESHOOTING FIM TASK 21-20-00-810-801-A UP TO PAGE 204 BLOCK 41, FOUND AND RESECURED LOOSE DUCTING UNDER FO'S FLOOR PANEL (222BF) IAW EMB145 AMM 21-20-04. - [SDR SIMA20220530001](https://openairdocs.org/sdr/SIMA20220530001.md): None · inoperative · May 30, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH OVERWING EMERGENCY LIGHT IAW EMB 145 AMM 33-50-07 OPS CHECK GOOD - [SDR SIMA20220526002](https://openairdocs.org/sdr/SIMA20220526002.md): Lamp · inoperative · May 26, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH EXTERIOR OVER WING EMERGENCY LIGHT INTERMITTENT-C/A-RESEATED LH EXTERIOR OVER WING EMERGENCY LAMP IAW EMB 145 AMM 33-50-10. OPC GOOD - [SDR SIMA20220521001](https://openairdocs.org/sdr/SIMA20220521001.md): Lamp · inoperative · May 21, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END. - [SDR SIMA20220507001](https://openairdocs.org/sdr/SIMA20220507001.md): Lamp · inoperative · May 7, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVERWING EMERGENCY LIGHT INOP-C/A-RAR LH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-07-000-801-A AND 33-50-07-400-801-A. OPC GOOD. END. - [SDR SIMA20220416002](https://openairdocs.org/sdr/SIMA20220416002.md): Lamp · inoperative · Apr 16, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > DURING PS-2 CHECK FOUND LH OVER WING EMERGENCY LIGHT INOP-C/A-RAR LH OVER WING EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO DEFECTS FOUND - [SDR SIMA20220331002](https://openairdocs.org/sdr/SIMA20220331002.md): None · none · Mar 31, 2022 · N902BC · Emb EMB145LR · Emergency Lighting > LH OVER WING EMERGENCY LIGHT INOP-C/A-RAR LH OVERWING EMERGENCY LAMP IAW EMB AMM 33-50-10 OPC GOOD Next page: https://openairdocs.org/aircraft/N902BC/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 = 'N902BC' AND registry_match = 'registration' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/aircraft/N902BC/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.