Boeing 737-76N
Service difficulty reports · 4,807
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "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 aircraft_model_key = '73776N' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 aircraft_model_key = '73776N' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWAA2016032150090Light · inoperativeRIGHT OVERWING EMER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016040150744Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STRINGER 8R - 9R. REPAIRED FRAME IAW EA.SDR SWAA2016041150743Structure · corrodedCHORD CORRODED AT INTERCOSTAL BELOW AIR STAIR DOOR, BETWEEN BS 294.5 - 328, STRINGER 23L. REPAIRED CHORD IAW EA.SDR SWAA2016040550624Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STRINGER 8R - 9R. REPAIRED FRAME IAW EA.SDR SWAA2016040450576Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 8R - 9R. REPAIRED FRAME IAW EA & SRM.SDR SWAA2016040450575Support Fitting · crackedAFT CARGO STANCHION SUPPORT CLIP CRACKED AT BS 865, LBL 10. R & R CLIP IAW SRM & DWG.SDR SWAA2016040150491Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STRINGER 8R - 9R. REPAIRED FRAME IAW EA.SDR SWAA2016040150490Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STRINGER 8R - 9R. REPAIRED FRAME IAW EA.SDR SWAA2016033150466Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R - 9R. REPAIRED FRAME IAW EA.SDR SWAA2016033150465Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STRINGER 8L - 9L. REPAIRED FRAME IAW EA.SDR SWAA2016033150464Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STRINGER 8L - 9L. REPAIRED FRAME IAW EA.SDR SWAA2016033150463Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STRINGER 8L - 9L. REPAIRED FRAME IAW EA.SDR SWAA2016032850226Fairing · delaminatedFUSELAGE FAIRING 193B OUTER SURFACE DELAMINATED. REPAIRED FAIRING IAW EA.SDR SWAA2016040650655Intercostal · corrodedINTERCOSTAL BELOW AIRSTAIR CORRODED, BETWEEN BS 312 - 328, STRINGER 23L. R & R INTERCOSTAL IAW SRM.SDR SWAA2016032950339Floor Support · corrodedCABIN FLOOR SUPPORT CORRODED AT BS 331, LBL 12. R & R SUPPORT IAW SRM.SDR SWAA2016032950338Floor Support · corrodedFLOOR SUPPORT CORRODED BETWEEN BS 315 - 325, LBL 12. R & R SUPPORT IAW SRM.SDR SWAA2016032850225Intercostal · crackedINTERCOSTAL CRACKED AT BS 320, LBL 45. R & R INTERCOSTAL IAW SRM.SDR SWAA2016032850224Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 284 - 290, BL 0. R & R INTERCOSTAL IAW SRM.SDR SWAA2016032150011Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2016040550623Bracket · crackedRIGHT WING TE WAFFLE BRACKET CRACKED AT NR 2 ENG PYLON. R & R BRACKET IAW SRM.SDR SWAA2016040150489Door Sill · corrodedFORWARD ENTRY DOOR, LOWER INNER CHORD CORRODED, MOP SILL, NEAR LOWER AFT CORNER. R & R CHORD IAW DWG.SDR SWAA2016040150488Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 887, STRINGER 22L. R & R SPLICE IAW SRM.SDR SWAA2016040150487Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 887, STRINGER 22L. R & R CLIP IAW SRM & DWG.SDR SWAA2016033150462Support · corrodedAFT CARGO FLOOR TO SIDEWALL SUPPORT TRIM COVER ON THE LT SIDE CORRODED, BETWEEN BS 867 - 887. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016033150461Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORRODED, BETWEEN BS 787 - 827, RBL 1. REPAIRED SUPPORT IAW EA.SDR SWAA2016040150521Threshold · corrodedFORWARD CARGO COMPARTMENT DOOR SUB THRESHOLD CORRODED, BETWEEN BS 440 - 592. R & R WEB IAW SRM & DWG.SDR SWAA2016031449877Lens · unsecureFORWARD SERVICE EMER EXIT LIGHT LENS FELL OFF. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016032850237Seat Track · corrodedINTERIOR SEAT TRACK CORRODED, BETWEEN BS 727B - 887, LBL 45. R & R SEAT TRACK IAW ER & EA.SDR SWAA2016032850236Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW ER & EA.SDR SWAA2016032350159Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016032250132Door Frame · crackedR1 DOOR FWD FRAME CUT OUT CRACKED AT BS 296, BETWEEN STRINGER 14R - 17R. R & R FRAME IAW SRM.SDR SWAA2016032150089Support · corrodedAFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 847 - 867, RBL 20. R & R SUPPORT IAW SRM.SDR SWAA2016032150088Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016032150087Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016032150086Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016032150085Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016032150084Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016032150083Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016032150082Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016032150081Support Angle · corrodedFORWARD CARGO BAY AT AFT BULKHEAD, RT PANEL LOWER CURVED SUPPORT ANGLE CORRODED, BETWEEN RBL 20 TO RBL 26. R & R ANGLE IAW SRM.SDR SWAA2016032150080Support Angle · corrodedFORWARD CARGO BAY AT AFT BULKHEAD, CTR PANEL LOWER SUPPORT ANGLE CORRODED, BETWEEN LBL 25 TO RBL 25. R & R ANGLE IAW SRM.SDR SWAA2016032150020Support · corrodedAFT CARGO BAY, RT FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 887 - 893, RBL 20. REPAIRED SUPPORT IAW SRM.SDR SWAA2016032150019Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016032150018Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016031449876Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016032250131Door Sill · corrodedAFT CARGO DOOR LOWER MAIN SILL, UPPER WEB ASSEMBLY CORRODED, BETWEEN BS 794.5 - 847, RBL 25. R & R WEB IAW SRM.SDR SWAA2016032250130Cargo Track · corrodedCARGO FLOOR TRACK CORRODED, BETWEEN BS 727E - 787, RBL 7.5. R & R TRACK IAW EA.SDR SWAA2016032250129Cargo Track · corrodedCARGO FLOOR TRACK CORRODED, BETWEEN BS 767 - 787, RBL 2.5. REPAIRED TRACK IAW EA.SDR SWAA2016032250128Cargo Track · corrodedCARGO FLOOR TRACK CORRODED, BETWEEN BS 767 - 787, LBL 2.5. REPAIRED FLOOR TRACK IAW EA.SDR SWAA2016032250127Floor Support · corrodedCARGO FLOORBEAM CORRODED, BETWEEN BS 767 - 787, LBL 12. REPAIRED BEAM IAW SRM.
Back to Boeing 737-76N