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 = '727281' 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 = '727281' 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 99ZZZX1770Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON C-1 DOOR SKIN.SDR 99ZZZX1767Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LEFT WING SURFACE (FORWARD OF NR 6 SPOILER OF PANEL.SDR 99ZZZX1766Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT ELEVATOR SKIN SURFACE STA 17.2 - STA 118.SDR 99ZZZX1765Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 29R AT STA 1090.SDR 99ZZZX1764Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 1070 - STA 1130 AT STR 29L. (BOTH STRINGER AND SPLICE WERE CORRODED).SDR 99ZZZX1763Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT ELEVATOR PANEL LOWER SURFACE (INBOARD END STA 17.5 - STA 66).SDR 99ZZZX1762Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LEFT WING UPPER SURFACE (FORWARD OF NR 7 SPOILER).SDR 99ZZZX1761Deicer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LT HORIZONTAL STABILIZER UPPER AFT TRAILING EDGE BEAM AREA BETWEEN NR 4 AND NR 5 HINGE ON ICE BREAKER.SDR 99ZZZX1760Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 27L BETWEEN STA 1070 - STA 1130.SDR 99ZZZX1759Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON UPPER SURFACE LT WING (ABOVE NR 7 SPOILER ACTUATOR).SDR 99ZZZX1320Stringer · corrodedDURING A C-CHECK, CORROSION NOTED ON STR 27R, STA 720E - STA 720F.SDR 99ZZZX1319Panel · corrodedDURING A C-CHECK, CORROSION NOTED ON LEFT ELEVATOR SKIN PANEL FORWARD OUTBOARD AREA.SDR 99ZZZX1318Stringer · corrodedDURING A C-CHECK, CORROSION NOTED ON STR 28L AT STA 1070 - STA 1130.SDR 99ZZZX1316Shear Ties · corrodedDURING A C-CHECK, CORROSION NOTED ON NUMEROUS SHEAR TIES AT STA 1148, STR 28L - STR 28R.SDR 99ZZZX1314Shear Ties · corrodedDURING A C-CHECK, CORROSION NOTED ON NUMEROUS SHEAR TIES STA 1130 STR 28L - STR 28R.SDR 99ZZZX1313Stringer · corrodedDURING A C-CHECK, CORROSION NOTED AT STA 440 ON STR 23R.SDR 99ZZZX1312Hinge · corrodedDURING A C-CHECK, CORROSION NOTED ON RT AFT EMERGENCY EXIT STEP HINGE.SDR 99ZZZX1309Support · corrodedDURING A C-CHECK, CORROSION NOTED AT FORWARD LAVATORY FLOOR SUPPORT STA 312.SDR 99ZZZX1308Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1130 LBL 24.75.SDR 99ZZZX1307Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1070 - STA 1110, LBL 45.5SDR 99ZZZX1306Floor Panel · corrodedDURING A C-CHECK, CORROSION NOTED IN FORWARD LAVATORY FLOOR PANEL FROM BULKHEAD TO STA 312.SDR 99ZZZX1305Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1050 - STA 1070, LBL 45.5.SDR 99ZZZX1304Skin · corrodedDUIRNG A C-CHECK, CORROSION NOTED ON LOWER RUDDER LEFT SURFACE.SDR 99ZZZX1303Panel · corrodedDURING A C-CHECK, CORROSION NOTED ON LT SLAT PANEL NR 6205.SDR 99ZZZX1302Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK AT STA 997, APPROXIMATELY 44.5 LBL.SDR 99ZZZX1301Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 312 LBL 24 ON FLOORBEAM (AFT OF COCKPIT DOOR).SDR 99ZZZX1300Web · corrodedDURING A C-CHECK, CORROSION NOTED ON WEB FORWARD OF VENT DOOR IN C2 DOOR.SDR 99ZZZX1299Intercostal · corrodedDURING A C-CHECK, CORROSION NOTED ON INTERCOSTAL AT STA 1110 - STA 1130 CENTER LINE.SDR 99ZZZX1298Stringer · corrodedDURING A C-CHECK, CORROSION NOTED ON STR 25L STA 440.SDR 99ZZZX1297Stringer · corrodedDURING A C-CHECK, CORROSION NOTED ON STR 24R STA 440.SDR 99ZZZX1296Fitting · corrodedDURING A C-CHECK, CORROSION NOTED AT BL ZERO, STA 1183, JACK PAD FITTING.SDR 99ZZZX1341Skin · corrodedDURING A C-CHECK, CORROSION NOTED ON SKIN PANEL, LEFT ELEVATOR OUTBOARD MOST CORNER LOWER SURFACE TRAILING EDGE.SDR 99ZZZX1330Skin · corrodedDURING A C-CHECK, CORROSION NOTED ON SKIN PANEL LT ELEVATOR LOWER SURFACE (STA 17.2 - STA 53.5 APPROXIMATELY).SDR 99ZZZX1325Skin · corrodedDURING A C-CHECK, CORROSION NOTED AT STA 1166 - STA 1183, RT BL ZERO ON SKIN.SDR 99ZZZX1324Panel · corrodedDURING A C-CHECK, CORROSION NOTED ON PANEL NR 9501, VERTICAL STABILIZER.SDR 99ZZZX1323Stringer · corrodedDURING A C-CHECK, CORROSION NOTED ON STR 27L AT STA 740.SDR 99ZZZX1322Panel · corrodedDURING A C-CHECK, CORROSION NOTED ON UPPER/LOWER SKIN PANEL, RT ELEVATOR STA 209 TO OUTBOARD TIP AND SKIN SEPARATING.SDR 99ZZZX1321Panel · corrodedDURING A C-CHECK, CORROSION NOTED ON UPPER/LOWER SKIN PANEL, RT ELEVATOR STA 209 TO OUTBOARD TIP AND SKIN SEPARATING.SDR 99ZZZX1317Shear Ties · corrodedDURING A C-CHECK, CORROSION NOTED ON NUMEROUS SHEAR TIES, STA 1166 STR 28L - STR 28R.SDR 99ZZZX1315Intercostal · corrodedDURING A C-CHECK, CORROSION NOTED ON INTERCOSTAL STR 29R - STA 1070 - STA 1090.SDR 99ZZZX1311Beam · corrodedDURING A C-CHECK, CORROSION NOTED ON RIGHT HORIZONTAL STABILIZER TRAILING EDGE UPPER BEAM.SDR 99ZZZX1310Angle · corrodedDURING A C-CHECK, CORROSION NOTED ON NR 6 LEADING EDGE SLAT INBOARD SLAT TRACK LOWER ATTACH ANGLE.SDR 99ZZZX1329Skin · corrodedDURING A C-CHECK, CORROSION NOTED IN NUMEROUS AREAS OF UPPER SURFACE OF SKIN LT WING SPAR FORWARD OF NR 5 AND NR 6 SPOILERS.SDR 99ZZZX1328Skin · corrodedDURING A C-CHECK, CORROSION NOTED ON SKIN STA 440 AT STR 25R.SDR 99ZZZX1327Skin · corrodedDURING A C-CHECK, CORROSION NOTED ON SKIN AT STA 440, STR 20R (AROUND OXYGEN BLOW-OUT DISC AREA).SDR 99ZZZX1326Shear Tie · corrodedDURING A C-CHECK, CORROSION NOTED AT STA 480, STR 22R ON SHEAR TIE TO FRAME.SDR 95ZZZZ203Spar · corrodedDURING C-CHECK INSPECTION, CORROSION WAS FOUND ALONG THE INSIDE OF THE FWD LOWER SPAR OF THE HORIZONTAL STABILIIZER.SDR HAC000002Keel Beam · corrodedIN THE PROCESS OF COMPLYING WITH SB 53-0176, KEEL BEAM CHORD PIN 65-56441-7 WAS FOUND TO BE BADLY CORRODED AT STA 970. DURING INSPECTION OF THE PART THERE ARE INDICATIONS THAT IT WASN'T CORROSION TREATED PROPERLY. THERE COULD BE MOISTURE BUILD UP IF DRAIN HOLSDR HAC000001Support Fitting · crackedTRUNNION SUPPORT FITTING REMOVED DUE TO CORROSION ON RIGHT WING LOWER REAR SPAR. DURING INSPECTION, A CRACK WAS FOUND IN BOLT HOLE. THE CRACK WAS 1 INCH LONG AND .3750 INCH DEEP. THE CRACK COULD HAVE BEEN CAUSED BY HARD LANDING OR FLAW IN CASTING. (X)
Back to Boeing 727-281