# Service difficulty reports: N807NN A list on [N807NN](https://openairdocs.org/aircraft/N807NN.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 · 107 reports - [SDR AALA202609163852](https://openairdocs.org/sdr/AALA202609163852.md): Hmu · inoperative · Sep 13, 2026 · N807NN · Boeing 737823 · Fuel Controlling System > AIRCRAFT WAS GROUNDED: NR 2 ENGINE FAIL AT 1200 FEET ON FINAL TO RW01L. DUE TO RIGHT ENGINE IN FLIGHT SHUTDOWN INTO CLT, VERIFY RIGHT FUEL TANK FUEL QTY VIA FUEL MEASURING STICKS. ALL READINGS ARE THE MINIMUM AT 2. CONFERRED WITH MOC AND DETERMINED THAT THE - [SDR AALA202607282561](https://openairdocs.org/sdr/AALA202607282561.md): Power Supply · inoperative · Jul 22, 2026 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT IN BASE MAINTENANCE: AFT LEFTHAND EMERGENCY CEILING LIGHT INOPERATIVE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY M1673 IAW AMM 33-51-06. - [SDR AALA202607134473](https://openairdocs.org/sdr/AALA202607134473.md): Floorbeam · corroded · Jul 12, 2026 · N807NN · Boeing 737823 · Fuselage Main, Floor Beam > AIRCRAFT IN BASE MAINTENANCE: CORROSION LEFT UPPER TEE FITTING MAIN CABIN FLOOR STA. 947 LBL 25 UNDER AND AROUND LAVATORY MOUNT. MAINTENANCE FABRICATED LOCATED AND DRILLED AND INSTALLED -1 T-CAP SECTION, -2 ANGLES AND (4EA) -3 STRAPS (4EA) AT FLOOR BEAM STA 94 - [SDR AALA202607137990](https://openairdocs.org/sdr/AALA202607137990.md): Floorbeam · corroded · Jul 12, 2026 · N807NN · Boeing 737823 · Fuselage Main, Floor Beam > AIRCRAFT IN BASE MAINTENANCE: CORROSION UPPER RIGHT INNER CHORD MAIN CABIN FLOOR STA. 986 RBL 50. MAINTENANCE REPLACE UPPER RIGHT INNER CHORD MAIN CABIN FLOOR BS 986 RBL 50 IAW SRM 51-40-05/ 51-40-02. - [SDR AALA202607133137](https://openairdocs.org/sdr/AALA202607133137.md): Angle · cracked · Jul 11, 2026 · N807NN · Boeing 737823 · Fuselage Miscellaneous Structure > AIRCRAFT IN BASE MAINTENANCE: RH ECS BAY AFT BULKHEAD MID SECTION AND IB SIDE UPPER ANGLE CRACKED. MAINTENANCE REPLACED ANGLE AND REPAIR SPLICE FOR RH ECS BAY AFT BULKHEAD IAW SRM 57-10-10-2R, PROCEDURE 5. - [SDR AALA202607100305](https://openairdocs.org/sdr/AALA202607100305.md): Repair · corroded · Jul 2, 2026 · N807NN · Boeing 737823 · Fuselage Main, Floor Beam > AIRCRAFT IN BASE MAINTENANCE: CORROSION EXISTING REPAIR LEFT UPPER TEE ANGLE MAIN CABIN FLOOR BS 986 LBL 50. MAINTENANCE REMOVED AND REPLACED 1EA FILLER IAW SRM 53-70-51-SR-6. - [SDR AALA202607154559](https://openairdocs.org/sdr/AALA202607154559.md): Flap Track · corroded · Jun 28, 2026 · N807NN · Boeing 737823 · Trailing Edge Flaps > UPON, REMOVAL, OF RIGHT WING, T/E. INBD AFT FLAP FOUND, INBD.AND OTBD.TRACKS, WITH PITTING CORROSION. MAINTENANCE REPLACED RT WING T/E INBD FLAP TRACKS IAW AMM 27-51-16. - [SDR AALA202607155904](https://openairdocs.org/sdr/AALA202607155904.md): Flap Track · corroded · Jun 26, 2026 · N807NN · Boeing 737823 · Trailing Edge Flaps > AIRCRAFT IN BASE MAINTENANCE: UPON, REMOVAL OF LEFT WING T/E.I/B. AFT. FLAP FOUND TRACKS WITH PITTING CORROSION. MAINTENANCE REPLACED L/H WING T/E I/B AFT FLAP TRACKS IAW B737NG AMM 27-51-16. - [SDR AALA202607150605](https://openairdocs.org/sdr/AALA202607150605.md): Balance Weight · corroded · Jun 24, 2026 · N807NN · Boeing 737823 · Rudder Miscellaneous Structure > AIRCRAFT IN BASE MAINTENANCE: RUDDER BALANCE WEIGHT SHOW SIGN OF CORROSION. MAINTENANCE REPLACED RUDDER BALANCE WEIGHTI AW B737-NG AMM 55-40-00-000-801C1 AND B737-NG-AMM-55-40-00-400-801C1. IPC VERIFIED IAW B737-NG-AIPC-27-21-11-22. - [SDR AALA202607106592](https://openairdocs.org/sdr/AALA202607106592.md): Support · cracked · Jun 16, 2026 · N807NN · Boeing 737823 · Fuselage Miscellaneous Structure > AIRCRAFT IN BASE MAINTENANCE: KEEL BEAM FWD ACCESS PANEL 3EA SUPPORTS FOUND CRACKED,REQ REPLACEMENT. MAINTENANCE REPLACED 3EA SUPPORTS AT KEEL BEAM FWD ACCESS PANEL IAW B737 NG SRM51-40-02. - [SDR AALA202509098073](https://openairdocs.org/sdr/AALA202509098073.md): Light · inoperative · Sep 7, 2025 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AT ROW 12FED INOPERATIVE. REMOVE AND REPLACED EMERGENCY LIGHT. PER AMM 33-51-03. - [SDR AALA202509090341](https://openairdocs.org/sdr/AALA202509090341.md): Light · inoperative · Sep 7, 2025 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AT ROW 4FED INOPERATIVE. REMOVE AND REPLACED EMERGENCY LIGHT. PER AMM 33-51-05. - [SDR AALA202506179829](https://openairdocs.org/sdr/AALA202506179829.md): Vapor Barrier · cracked · Jun 17, 2025 · N807NN · Boeing 737823 · Fuselage Main, Bulkhead > AIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, LEFT HAND WHEEL WELL, AT STA 663, LBL 31.82. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2. - [SDR AALA202503146105](https://openairdocs.org/sdr/AALA202503146105.md): Slide · dislodged · Mar 13, 2025 · N807NN · Boeing 737823 · Escape Slide > AIRCRAFT WAS GROUNDED: R1 DOOR SLIDE FOUND DISLODGED. REMOVE AND REPLACED R1 DOOR SLIDE. PER 08L22125001. - [SDR AALA202408229041](https://openairdocs.org/sdr/AALA202408229041.md): Guard · loose · Aug 11, 2024 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT WAS NOT GROUNDED: FLIGHT DECK EMERGENCY EXIT SWITCH GUARD IS LOOSE. REMOVE AND REPLACED SWITCH GUARD. PER AMM 25-11-00. - [SDR AALA202408129041](https://openairdocs.org/sdr/AALA202408129041.md): Switch · damaged · Aug 11, 2024 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT WAS NOT GROUNDED: FLIGHT DECK EMERGENCY EXIT SWITCH GUARD IS LOOSE. (OPEN). - [SDR AALA202403134251](https://openairdocs.org/sdr/AALA202403134251.md): Lens · missing · Mar 12, 2024 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED AFT GALLEY EMERGENCY EXIT LIGHT ASSEMBLY. PER AMM 33-51-01. FUNCTIONAL CHECK GOOD CHECK GOOD. - [SDR AALA202401084853](https://openairdocs.org/sdr/AALA202401084853.md): Door Latch · lack of lube · Jan 6, 2024 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DOES NOT LATCH AND DIFFICULT TO OPEN. CLEANED AND LUBE DOOR LATCH. DID A POST INSTALLATION CHECK. PER AMM 52-51-02. - [SDR AALA202401036921](https://openairdocs.org/sdr/AALA202401036921.md): Lamp · inoperative · Jan 1, 2024 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT WAS NOT GROUNDED: R2 SLIDE EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-LAMPED R2 SLIDE EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04. ALL CHECKS NORMAL. - [SDR AALA202312110983](https://openairdocs.org/sdr/AALA202312110983.md): Screw · backed out · Dec 9, 2023 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR DOES NOT FULLY OPEN. FOUND ONE SCREW SLIGHTLY PROTRUDING INTO UPPER CHANNEL IMPEDING DOOR UPPER ROLLER. TIGHTENED SCREW. OPERATIONAL CHECK NORMAL. - [SDR AALA202311094580](https://openairdocs.org/sdr/AALA202311094580.md): Bolt · corroded · Sep 26, 2023 · N807NN · Boeing 737823 · Vertical Stabilizer > AIRCRAFT IN BASE MAINTENANCE: CORROSION ON BOLT OF FRONT SPAR FITTING RIGHT HAND SIDE AT VERTICAL STABILIZER. LOCATED AT STA 1016. REPLACED WITH IDENTICAL PART (PART NUMBER 170A1611-3). PER JOB CARD 08C32253004. - [SDR AALA202309216277](https://openairdocs.org/sdr/AALA202309216277.md): Strap · corroded · Sep 14, 2023 · N807NN · Boeing 737823 · Wing, Attach Fittings > AIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING, LEADING EDGE TO WING LOWER ATTACH STRAP ASSEMBLY LOCATED AT FRONT SPAR BETWEEN WS 643.50 TO WS 667.50. REPAIRED STAP PER EA 347564. - [SDR AALA202404115426](https://openairdocs.org/sdr/AALA202404115426.md): Rib · cracked · Sep 8, 2023 · N807NN · Boeing 737823 · Horizontal Stabilizer, Spar/Rib > AIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 3, LOCATED AT STABILIZER STA 129.50. REPAIRED RIB PER SRM 55-10-09-2R-4. **SUPPLEMENTAL REPORT FOR AALA202309215426 TO ADD SECTION 5 PART INFORMATION AND TO REMOVE THE LEVEL 2 IN - [SDR AALA202309215426](https://openairdocs.org/sdr/AALA202309215426.md): Unknown · unknown · Sep 8, 2023 · N807NN · Boeing 737823 · Horizontal Stabilizer, Spar/Rib > AIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 3, LOCATED AT STABILIZER STA 129.50. REPAIRED RIB PER SRM 55-10-09-2R-4. - [SDR AALA202308022746](https://openairdocs.org/sdr/AALA202308022746.md): Lamp · inoperative · Jul 29, 2023 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE AT SEAT 12D. REPLACED POWER SUPPLY PER AMM 33-51-06. - [SDR AALA202305097269](https://openairdocs.org/sdr/AALA202305097269.md): Flashlight · inoperative · May 7, 2023 · N807NN · Boeing 737823 · Emergency Lighting > AIRCRAFT NOT GROUNDED: AFT GALLEY JUMP SEAT FLASHLIGHT GREEN CHARGING LIGHT IS NOT FLASHING. REMOVED AND REPLACED FLASHLIGHT. - [SDR AALA202304186223](https://openairdocs.org/sdr/AALA202304186223.md): Rivet · sticking · Mar 29, 2023 · N807NN · Boeing 737823 · Passenger/Crew Doors > AIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR WILL NOT STAY IN RETAINING CLIPS IN STOWED POSITION. **SUPPLEMENTAL REPORT FOR AALA202303316223: REMOVED AND REPLACED MISSING RIVET ON RETAINING CLIP ON THE 1R DOOR** (CLOSED) - [SDR AALA202303316223](https://openairdocs.org/sdr/AALA202303316223.md): Unknown · unknown · Mar 29, 2023 · N807NN · Boeing 737823 · Passenger/Crew Doors > AIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR WILL NOT STAY IN RETAINING CLIPS IN STOWED POSITION. **SUPPLEMENTAL REPORT REQUIRED** (OPEN) - [SDR AALA202303145585](https://openairdocs.org/sdr/AALA202303145585.md): Door Latch · sticking · Mar 13, 2023 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: AIRCRAFT IN LAVATORY E DOOR DIFFICULT TO UNLATCH FROM WITHIN LAVATORY. REMOVED AND REPLACED LAVATORY E DOOR LATCH. - [SDR AALA202302179937](https://openairdocs.org/sdr/AALA202302179937.md): None · loose · Feb 16, 2023 · N807NN · Boeing 737823 · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: BRACKET WHERE GIRT BAR IS INSERTED ON SERVICE DOOR SIDE IS LOOSE. ADJUSTED GIRT BAR RETAINER CLIP ON R1 DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. - [SDR AALA202301170925](https://openairdocs.org/sdr/AALA202301170925.md): Module · inoperative · Jan 12, 2023 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR SECURITY AUTO LOCK SYSTEM INOPERATIVE. REPLACED FLIGHT DECK DOOR ACCESS SYSTEM MODULE ASSEMBLY PER AMM 52-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. - [SDR AALA202210246386](https://openairdocs.org/sdr/AALA202210246386.md): Fitting · loose · Oct 22, 2022 · N807NN · Boeing 737823 · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY SLIDE GIRT BAR STOW CLIP LOOSE. RESECURED R1 DOOR EMERGENCY SLIDE GIRT BAR STOW CLIP. - [SDR AALA202210143926](https://openairdocs.org/sdr/AALA202210143926.md): None · loose · Oct 13, 2022 · N807NN · Boeing 737 · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: GIRT BAR ON FORWARD SERVICE DOOR WILL NOT STAY IN RETRACTED DETENT UP POSITION. SECURED GIRT BAR RETAINER CLIPS. - [SDR AALA202207053810](https://openairdocs.org/sdr/AALA202207053810.md): Regulator Valve · inoperative · Jul 1, 2022 · N807NN · Boeing 737 · Pneumatic Distribution System > AIRCRAFT WAS GROUNDED: DEPARTED AUS, AFTER LEVEL OFF AT 24000 FT, FOUND WE COULD NOT COOL THE CABIN SUFFICIENTLY AND RETURNED TO AUS. REMOVED AND REPLACED HIGH STAGE REGULATOR PER JOB CARD 08L40036002. REMOVED AND REPLACED PRESSURE VALVE (AALA202207055589). - [SDR AALA202207055589](https://openairdocs.org/sdr/AALA202207055589.md): Valve · inoperative · Jul 1, 2022 · N807NN · Boeing 737 · Pneumatic Distribution System > AIRCRAFT WAS GROUNDED: DEPARTED AUS, AFTER LEVEL OFF AT 24000 FT, FOUND WE COULD NOT COOL THE CABIN SUFFICIENTLY AND RETURNED TO AUS. REMOVED AND REPLACED HIGH STAGE REGULATOR (AALA202207053810) PER JOB CARD 08L40036002. REMOVED AND REPLACED PRESSURE VALVE. - [SDR AALA202204010912](https://openairdocs.org/sdr/AALA202204010912.md): Shade · damaged · Mar 31, 2022 · N807NN · Boeing 737 · Door Windows > AIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT ROW 17DEF WINDOW SHADE DAMAGED. REMOVED AND REPLACED WINDOW SHADE AT ROW 17DEF. PER AMM. 52-22-51 - [SDR AALA202203216481](https://openairdocs.org/sdr/AALA202203216481.md): Hanger Assy · out of adjust · Mar 18, 2022 · N807NN · Boeing 737* · Escape Slide > AIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR HANGER RIGHT SIDE LOOSE. ADJUSTED R1 DOOR GIRT BAR HANGER ON RIGHT SIDE. - [SDR AALA202202219948](https://openairdocs.org/sdr/AALA202202219948.md): Bracket · loose · Feb 20, 2022 · N807NN · Boeing 737* · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: GIRT BAR LOOSE AT DOOR 1R. ADJUSTED GIRT BAR BRACKET IAW AMM 25-66-01, OPS CHECK GOOD. - [SDR AALA202111084857](https://openairdocs.org/sdr/AALA202111084857.md): Door · damaged · Oct 30, 2021 · N807NN · Boeing 737* · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DAMAGED AFT LEFT. **SUPPLEMENTAL REPORT FOR AALA202111034857: OPERATE AND INSPECTED LAVATORY D BI-FOLD DOOR PER CMM 25-40-64.** (CLOSED) - [SDR AALA202111034857](https://openairdocs.org/sdr/AALA202111034857.md): None · none · Oct 30, 2021 · N807NN · Boeing 737* · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DAMAGED AFT LEFT. **SUPPLEMENTAL REPORT REQUIRED** (OPEN) - [SDR AALA202109074995](https://openairdocs.org/sdr/AALA202109074995.md): Megaphone · inoperative · Sep 6, 2021 · N807NN · Boeing 737823 · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: FWD MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE WITH SERVICEABLE UNIT, OPS CHECK GOOD. - [SDR AALA202108231528](https://openairdocs.org/sdr/AALA202108231528.md): Bustle · out of alignment · Aug 21, 2021 · N807NN · Boeing 737823 · Escape Slide > AIRCRAFT WAS NOT GROUNDED: SLIDE BUSTLE 1R DOOR MISALIGNED. ACCOMPLISHED AND COMPLETED FUNCTIONAL OPERATION OF GIRT BAR INCLUDING ADJUSTMENT OF THE SLIDE BUSTLE PER 25-61-00. - [SDR AALA202108231408](https://openairdocs.org/sdr/AALA202108231408.md): Attach Angle · worn · Aug 20, 2021 · N807NN · Boeing 737823 · Horizontal Stabilizer Structure > AIRCRAFT IN BASE MAINTENANCE: OUT-OF-ROUND HOLES IN AFT ATTACH ANGLE FLANGE OF RH HORIZONTAL STABILIZER RIB AT STA 92.07. REPLACED ATTACH ANGLE WITH NEW IAW AARD 51-00-05-1 AND EA307878. - [SDR AALA202108195642](https://openairdocs.org/sdr/AALA202108195642.md): Hinge · dirty · Aug 17, 2021 · N807NN · Boeing 737823 · Fuselage, Door Hinge > AIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. DISCOVERED DEBRIS ON FLOOR AT LOWER DOOR PATH. DOOR HINGE STIFF AND SQUEAKING. CLEANED FLOOR AT BOTTOM OF DOOR. LUBRICATED DOOR HINGE FROM TOP TO BOTTOM. - [SDR AALA202107210647](https://openairdocs.org/sdr/AALA202107210647.md): Rail · binding · Jul 20, 2021 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: LAVATORY 4 DOOR STICKS CLOSED. UPPER RAIL BINDING. ADJUSTED RAIL. - [SDR AALA202107143313](https://openairdocs.org/sdr/AALA202107143313.md): Sliding Window · burned · Jul 13, 2021 · N807NN · Boeing 737823 · Flight Compartment Windows > AIRCRAFT WAS GROUNDED: L2 SLIDING WINDOW CAPTAIN HAS A BURN MARK IN LOWER FWD CORNER. REMOVED AND REPLACED L2 WINDOW I.A.W M.M 56-12-12. - [SDR AALA202106189029](https://openairdocs.org/sdr/AALA202106189029.md): O-Ring · leaking · Jun 14, 2021 · N807NN · Boeing 737823 · Turbine Engine Oil System > AIRCRAFT WAS GROUNDED: RH ENGINE OIL QUANTITY DECREASED BY 12 QUARTS INFLIGHT, FLIGHT DIVERTED TO PIT. REPLACED O-RING AT SCAVENGE OIL FILTER TRANSMITTER WITH NEW IAW AMM 79-21-07, LEAK AND OPS CHECK GOOD. - [SDR AALA202106089010](https://openairdocs.org/sdr/AALA202106089010.md): Striker · dirty · Jun 7, 2021 · N807NN · Boeing 737823 · Fixed Inner Doors > AIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO OPEN. CLEANED COCKPIT DOOR STRIKER REF AMM 52-51-02. - [SDR AALA202105176027](https://openairdocs.org/sdr/AALA202105176027.md): Girt Bar · loose · May 13, 2021 · N807NN · Boeing 737823 · Emergency Equipment > AIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR CLIP LOOSE. ADJUSTED AFT GIRT BAR CLIP, OPS CHECK GOOD. - [SDR AALA2020090109016](https://openairdocs.org/sdr/AALA2020090109016.md): Rib · cracked · Aug 26, 2020 · N807NN · Boeing 737823 · Horizontal Stabilizer, Spar/Rib > AIRCRAFT IN BASE MAINTENANCE: FOUND 0.750 INCH CRACK ON RIB ON RIGHT HAND HORIZONTAL STABILIZER AT STATION 92.70, 3RD STIFFENER FROM THE FRONT SPAR.. REMOVED AND REPLACED RIB PER SRM 55-10-09-2R-4. Next page: https://openairdocs.org/aircraft/N807NN/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 = 'N807NN' AND registry_match = 'registration' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/aircraft/N807NN/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.