N922UP, cancelled Jan 8, 2008
Service difficulty reports · 173
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N922UP' AND deregistration_id = 'N922UP-2008-01-08' 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 n_number = 'N922UP' AND deregistration_id = 'N922UP-2008-01-08' 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 UPS99229439Hinge · corrodedINSPECTION TYPE:C+SI, RT I/B AILERON CENTERING HINGE CORRODED. CENTERING HINGE REMOVED AND REPLACED IAW 27-10-01.SDR UPS99229440Fitting · crackedINSPECTION TYPE:C+SI, STRINGER 8 AFT OF BS 1183 LT LOWER FITTING FOUND CRACKED. FITTING REMOVED AND NEW FITTING INSTALLED IAW SRM 51-30-2 AND MM 53-11-00.SDR UPS99229325Stringer · damagedINSPECTION TYPE:C+SI, DAMAGE STR 22 BS 700 RT AT FRAME ATTACH POINT. STRINGER REPAIRED AS PER SRM 53-10-3 FIG 1 DETAIL 2.SDR UPS99229326Panel · corrodedINSPECTION TYPE:C+SI, ACCESS PANEL NR 8 FOR NR 3 FUEL TANK CORRODED. PANEL REPLACED PER MM 28-11-21.SDR UPS99229434Stringer · crackedINSPECTION TYPE:C+SI, STR 24 LT CRACKED AT FRAME ATTACH POINTS. BS 420 STR 24L REPLACED BETWEEN BS 360 AND BS 440 IAW SRM 51-30-2.SDR UPS99229433Stringer · crackedINSPECTION TYPE:C+SI, STR 21 RT CRACKED AT FRAME ATTACH POINTS BS 380. STRINGER REPAIRED IAW SRM 53-10-3 FIG 1.SDR UPS99229432Stringer · crackedINSPECTION TYPE:C+SI, STR 23 RT CRACKED AT FRAME ATTACH POINTS BS 380 STR 23 RT. REPLACED BETWEEN BS 360 AND 440 IAW SRM 51-30-2.SDR UPS99229431Stringer · crackedINSPECTION TYPE:C+SI, STR 23 LT CRACKED AT FRAME ATTACH POINT BS 400 STR 23 LT. REPLACED IAW SRM 53-10-2 BETWEEN BS 360 AND BS 440.SDR UPS99229430Stringer · crackedINSPECTION TYPE:C+SI, STR 22 LT DAMAGED AT FRAME ATTACH POINT BS 400. CRACKED STR 22 LT SECTION REPLACED BETWEEN BS 390 AND BS 440 IAW SRM 53-10-2.SDR UPS99229426Stringer · crackedINSPECTION TYPE:C+SI, STR 25 LT DAMAGED AT FRAME ATTACH POINTS BS 420 LT. CRACKED STRINGER REPAIRED IAW SRM 53-10-2 FIG 1 DETAIL 2.SDR UPS99229327Casting · wornINSPECTION TYPE:C+SI, NR 5 JACKSCREW FAIRING, AFT BEARING WORN. BEARING CASTING REPLACED PER DWG 65-26786 AND SRM 51-30-2.SDR UPS99229510Panel · corrodedINSPECTION TYPE:C+SI, NR 3 TANK I/B AND O/B BOOST PANELS CORRODED. PANELS REPLACED IAW MM 12-30-06.SDR UPS99229441Frame · crackedINSPECTION TYPE:C+SI, AFT CARGO DOOR MOVABLE FAIRING IS CRACKED AT THE LOWER RAIL FWD FRAME ATTACH POINT. REPAIRED FRAME IAW SRM 51-40-3 FIG 1.SDR UPS99229435Stringer · crackedINSPECTION TYPE:C+SI, STRINGER 24 RT CRACKED AT FRAME ATTACH POINTS. STR 24 RT REPLACED BETWEEN BS 360 AND BS 440 IAW SRM 51-30-2.SDR UPS99229427Stringer · crackedINSPECTION TYPE:C+SI, STRINGER 25 RT DAMAGED BS 420 AT FRAME ATTACH POINTS. CRACKED STRINGER 25 RT REPLACED BETWEEN BS 360 AND BS 440 IAW SRM 51-30-2.SDR UPS99229329Panel · corrodedINSPECTION TYPE:C+SI, NR 1 ACCESS PANEL RHS FOR NR 2 INTEGRAL SECTION CORRODED. PANEL REPLACED IAW MM 28-11-21.SDR UPS99229328Ring · corrodedINSPECTION TYPE:C+SI, RT WING NR 3 FUEL TANK ACCESS PANEL CLAMP UP RINGS CORRODED ON NR 2 THRU NR 14. CLAMP UP RINGS REPLACED IAW MM 28-11-21.SDR UPS99229446Skin · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON LAP STR 19 BETWEEN BS 660 AND 680 RT SIDE. LAP REPAIRED IAW UPS EO B727-5330-0509 APP 8.3.SDR UPS99229348Hinge · wornINSPECTION TYPE:C+SI, NR 9 SPOILER I/B AND O/B HINGE CASTINGS WORN ON RT WING TRAILING EDGE. WORN CASTINGS REMOVED AND REPLACED WITH NEW CASTINGS IAW SRM 51-30-2 & DRAWING 65-16216.SDR UPS99229331Stringer · corrodedINSPECTION TYPE:C+SI, CORROSION IN STR 23, BS 700 RHS. STRINGER REPAIRED IAW SRM 53-10-3 FIG 1 DETAIL 1.SDR UPS99229330Casting · wornINSPECTION TYPE:C+SI, NR 8 SPOILER O/B HINGE CASTING WORN ON RT WING T/E. CASTING REPLACED IAW DWG 65-16216.SDR UPS99229347Bracket · crackedINSPECTION TYPE:C+SI, NR 3 FLAP TRACK MID FAIRING ANGLE BRACKET CRACKED AT FWD END OF O/B ROLLER TRACK. CRACKED ANGLE BRACKET REPLACED PER SRM 51-10-1 AND SRM 57-20-2 FIG 4.SDR UPS99229437Skin · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON LAP AT BS 600-620 STR 19 RT SIDE INTERNAL SURFACE. LAP REPAIRED IAW UPS EO B727-5330-0509 APPENDIX 8.3/8.4 FROM BS 600-700 STR 19 RT.SDR UPS99229333Casting · corrodedINSPECTION TYPE:C+SI, NR 6 FLAP TRACK MID FAIRING FWD HINGE CASTING CORRODED AT LUGS. CASTING REPLACED IAW DWG 65-21795.SDR UPS99229332Channel · crackedINSPECTION TYPE:C+SI, NR 5 FLAP TRACK AFT FAIRING CRACK IN CHANNEL SECTION AT UPPER O/B ATTACH POINT. CHANNEL SECTION REPLACED IAW SRM 51-20-1 FIG 7 AND SRM 57-20-2 FIG 4.SDR UPS99229266Casting · corrodedINSPECTION TYPE:C+SI, NR 8 FLAP TRACK MID FAIRING FWD ATTACH CASTING CORRODED. CASTING REPLACED IAW SRM 51-30-02.SDR UPS99229265Casting · crackedINSPECTION TYPE:C+SI, NR 1 FLAP TRACK MID FAIRING FWD ATTACH CASTING CRACKED. CASTING REPLACED IAW SRM 51-30-2.SDR UPS99229421Frame · crackedINSPECTION TYPE-C+SI, SUSPECT CRACK CARGO DOOR (FWD) FWD HINGE FRAME (DOOR INTERIOR). FWD HINGE FRAME REPLACED IAW DWG 69-18203.SDR UPS99229420Angle · crackedINSPECTION TYPE-C+SI, SUSPECT CRACK FWD CARGO DOOR (LWR) FWD HINGE AT FRAME SUPPORT ANGLE. SUPPORT ANGLE FABRICATED AND INSTALLED PER DWG 69-18203.SDR UPS99229258Panel · corrodedINSPECTION TYPE:C+SI NR 1 FUEL TANK INBD BOOST PUMP ACCESS PANEL CORRODED. PANEL REPLACED IAW MM 28-22-21.SDR UPS99229257Panel · corrodedINSPECTION TYPE:C+SI NR 1 FUEL TANK OB BOOST PUMP ACCESS PANEL CORRODED. PANEL REPLACED PER MM 28-22-21.SDR UPS99229429Track · corrodedINSPECTION TYPE:C+SI, NR 3 FLAP TRACK FWD ATTACH LUG HAS LIGHT SURFACE CORROSION ON I/B FACE (ON WING). REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (UPS FILE NR 727-57-2052).SDR UPS99229428Track · corrodedINSPECTION TYPE:C+SI, NR 4 FLAP TRACK FWD ATTACH LUG ON WING HAS LIGHT SURFACE CORROSION. REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (UPS FILE NO 727-57-2052).SDR UPS99229339Track · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON NR 6 FLAP TRACK FWD ATTACH LUG. REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (FILE NR 727-57-2052).SDR UPS99229338Track · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON NR 7 FLAP TRACK FWD ATTACH LUG I/B AND O/B. REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (FILE NR 727-57-2052).SDR UPS99229337Track · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON NR 8 FLAP TRACK FWD ATTACH LUG I/B SIDE. REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (FILE NR 727-57-2052).SDR UPS99229336Track · corrodedINSPECTION TYPE:C+SI, SURFACE CORROSION ON NR 5 FLAP TRACK FWD ATTACH LUG. REPAIR CARRIED OUT IAW SMRO EO 99-08-003 (FILE NR 727-57-2052).SDR UPS99229269Skin · crackedINSPECTION TYPE:C+SI, NR 3 LE FLAP HAS CRACK AROUND RIVET ON ANTI-ICE SKIN CENTER SKIN BETWEEN CENTER HINGE AND INBOARD HINGE. ANTI-ICE SKIN REPAIRED PER EO B727-5750-3082.SDR UPS99229443Post · crackedINSPECTION TYPE:C+SI, CRACK FOUND IN INTERNAL DOUBLER LT WINDOW POST 5 INCHES ABOVE POINT F. WINDOW POST REPAIRED IAW UPS EO B727-5310-0012 APP D.SDR UPS99229442Stair · corrodedINSPECTION TYPE:C+SI, CORROSION EVIDENT ABOVE NR 7 STAIRTHREAD FORWARD SUPPORT ANGLE ON RISER LOWER SURFACE. REPAIRED IAW SRM ADDENDUM EO 10-26-95.SDR UPS99229352Seat Track · gougedINSPECTION TYPE:C+SI, SEAT TRACK AT BS 910 LBL 45.5 BADLY GOUGED. NEW SEAT TRACK SPLICED IN IAW SRM 53-10-5.SDR UPS99229351Cleat · crackedINSPECTION TYPE:C+SI, CRACKED CLEAT DETECTED AT BS 560 BELOW MAIN CARGO DOOR SUPPORT FITTING. REPAIRED ANGLES IAW SRM 51-40-3.SDR UPS99229350Cleat · crackedINSPECTION TYPE:C+SI, CRACKED CLEAT FOUND AT BS 520 BELOW MAIN CARGO DOOR SUPPORT FITTING. CRACK STOP DRILLED PER SRM 51-10-1, REPAIRED ANGLES IAW SRM 51-20-3.SDR UPS99229349Cleat · crackedINSPECTION TYPE:C+SI, CRACKED CLEAT DETECTED AT BS 487.1 BELOW MAIN CARGO DOOR SUPPORT FITTING. CLEAT STOP DRILLED PER SRM 51-10-1.SDR UPS99229275Support · crackedINSPECTION TYPE:C+SI DUCT SUPPORT CRACKED BS1090 LBL 45.5. NEW STRAP FABRICATED PER SRM 51-20-1 AND FITTED PER SRM 51-30-2.SDR UPS99229272Skin · crackedINSPECTION TYPE:C+SI, NR 3 LEADING EDGE FLAP HAS A CRACK AROUND RIVET ON ANTI ICE SKIN. ANTI-ICE SKIN REPAIRED IAW EOB727-5750-3082.SDR UPS99229267Skin · crackedINSPECTION TYPE:C+SI, CRACK FOUND ON FUSELAGE SKIN BS 243.7 AFT ROW 6TH FASTENER DOWN (BET WEEN S14 AND S15 LH). REPAIR CARRIED OUT IAW SRM 53-30-3 FIG 3.SDR UPS99229449Track · crackedINSPECTION TYPE:C+SI, NR 3 FLAP TRACK SUSPECT CRACK AT AFT END OF TRACK. FLAP TRACK REMOVED AND REPLACED IAW TC C57-581-04-03.SDR UPS99229321Track · crackedINSPECTION TYPE:C+SI, CRACK ON NR 5 FLAP TRACK. TRACK REPLACED, REF TC C57-581-04-4D FOR INSTALLATION.SDR UPS99229450Skin · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON SKIN BS 1175 STR 6L. SKIN REPAIR CARRIED OUT IAW SRM 53-30-3 FIG 1 BETWEEN STR 5L AND STR 8L BS 1183 TO 1170.
Back to N922UP, cancelled Jan 8, 2008