N546JN
Service difficulty reports · 146
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 = 'N546JN' AND registry_match = 'registration' 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 = 'N546JN' AND registry_match = 'registration' 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 KO0R201510050157Door Frame · corrodedFORWARD LOWER CARGO DOOR, FWD LOWER CUT OUT FRAME IS CORRODED AT FS 879.SDR KO0R201510050156Floor Support · corrodedBODY STATION 1741, LBL 50 - 68, WL 79 MAIN DECK FLOOR SUPPORT HAS CORROSION.SDR KO0R201510050155Floor Panel · crackedFLOOR PANEL UNDER RT OBSERVERS SEAT IS CRACKED.SDR KO0R201510010154Attach Bracket · corrodedRIGHT MAIN WW DOOR, RETRACTION LINK ATTACH BRACKET IS CORRODED.SDR KO0R201510010153Skin · corrodedLEFT WING UPPER SURFACE AT ABOUT XW152, 57" AFT OF THE FRONT SPAR HAS SURFACE CORROSION.SDR KO0R201510010152Skin · corrodedRIGHT WING UPPER SURFACE HAS SURFACE CORROSION AT ABOUT OXRS 230 ALONG THE FWD SPAR.SDR KO0R201510010151Skin · corrodedLEFT WING LOWER SURFACE HAS LIGHT SURFACE CORROSION ON WING TIP AT DRAIN HOLE.SDR KO0R201509160141Skin · corrodedRIGHT WING LOWER SKIN HAS CORROSION AT XORS 1093.629, ABOUT 16" AFT OF THE FWD SPAR.SDR KO0R201509160140Door Frame · corrodedFORWARD LOWER CARGO DOOR, FWD LOWER CUT OUT FRAME, CORRODED AT FUSELAGE STATION 879.SDR KO0R201509160139Skin · corrodedLEFT WING LOWER SKIN IS CORRODED AT THE REAR SPAR AREA AT XORS 1093.629.SDR KO0R201508070136Longeron · corrodedSTATION 1365 TO 1380, LONGERON 28R EXTERNAL LONGERON HAS CORROSION.SDR KO0R201507210135Longeron · corrodedBODY STATION 1371 TO 1386, LONGERON 28L EXTERNAL STRINGER UPPER LEG HAS CORROSION.SDR KO0R201507210134Skin · crackedNUMBER 3 AC BAY ACCESS DOOR EXTERNAL SKIN AT TOP EDGE, 11 1/2" TO 16" AFT OF LE IS CRACKED.SDR KO0R201507210133Skin · corrodedRIGHT WING UPPER SURFACE HAS CORROSION AT ABOUT XORS 750, 41" FROM THE REAR SPAR.SDR KO0R201507210132Skin · corrodedRIGHT WING UPPER SURFACE HAS CORROSION AT ABOUT XORS 433, 33" FWD OF THE REAR SPAR.SDR KO0R201507140127Skin · corrodedRIGHT WING LOWER SURFACE HAS CORROSION AROUND VENT HOLE AT ABOUT XORS 826, ABOUT 22" AFT OF THE FRONT SPAR.SDR KO0R201507140126Angle · corrodedSTATION 1521, PRESS BULKHEAD FWD SIDE IN WW WL 78, BL 0 T ANGLE HAS CORROSION.SDR KO0R201507140125Stiffener · corrodedRIGHT TORQUE BOX UNDER WING BARREL HAS EVIDENCE OF CORROSION INSIDE KEEL BEAM ACCESS HOLE, ON VERTICAL STIFFENER AT APPROX STATION 1383, RBL 37.SDR KO0R201507140124Spar Cap · corrodedLEFT WING TE SPAR CAP AT APPROX STATION XORS 680 HAS CORROSION.SDR KO0R201507140123Longeron · corrodedMAIN DECK STATION 1179, LONGERON 23R HAS CORROSION UNDER SIDE OF LONGERON RT SIDE.SDR KO0R201507140122Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 110 AT STRINGER 11L.SDR KO0R201507140121Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 110 AT STRINGER 12L.SDR KO0R201507140120Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 108 AT STRINGER 13L.SDR KO0R201507140119Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 17 AT STRINGER 17R & 18R.SDR KO0R201507140118Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 17 AT STRINGER 16R & 17R.SDR KO0R201507140117Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 13 AT STRINGER 17R.SDR KO0R201507140116Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 30 AT STRINGER 15R.SDR KO0R201507140115Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 0 AT STRINGER 15.SDR KO0R201507140113Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 103 AT STRINGER 17R.SDR KO0R201507140112Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 112 AT STRINGER 16R.SDR KO0R201507140111Skin · corrodedCENTER WING TANK UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 106 AT STRINGER 16R.SDR KO0R201507140110Skin · corrodedCENTER WING TANK, UPPER SKIN EXTERNAL SURFACE IS CORRODED AT XCW 83 AT RBL 106 BETWEEN STRINGERS 17 & 18.SDR KO0R201507140109Skin · corrodedRIGHT WING TIP LOWER SURFACE HAS CORROSION OTBD OF ACCESS PANELS 628FW & 628HW.SDR KO0R201507070108Spar · corrodedRIGHT WING REAR SPAR LOWER CHORD IS CORRODED AT XORS 738.SDR KO0R201507070107Thrust Link · crackedNUMBER 2 PYLON RT THRUST LINK LUG IS CRACKED.SDR KO0R201507070106Seat Track · crackedMAIN DECK SEAT TRACK AT RBL 80 IS CRACKED BETWEEN STATION 755 & 775.SDR KO0R201507070105Skin · corrodedLEFT WING LOWER SKIN IS CORRODED AT OXRS 530 AT VENT HOLE.SDR KO0R201507070104Longeron Splice · crackedSTATION 1531 5-0, LONGERON 12L SPLICE STRAP IS CRACKED BETWEEN FASTENERS.SDR KO0R201507070103Longeron Splice · crackedSTATION 1531 5-123, LONGERON 2L SPLICE STRAP IS CRACKED BETWEEN FASTENERS.SDR KO0R201506260102Skin · corrodedRIGHT WING UPPER SURFACE HAS CORROSION AT XORS 231 AT STRINGER 15, 37" AFT OF THE FRONT SPAR.SDR KO0R201506260101Skin · corrodedRIGHT WING UPPER SURFACE HAS CORROSION AT XORS 231 AT THE FRONT SPAR.SDR KO0R201506260100Stringer · crackedIN THE CTR WING TANK STRINGER 52 IS CRACKED FROM XCW 47 OTBD LT TO XCW 53.SDR KO0R201506020066Seat Track · crackedMAIN DECK SEAT TRACK, AS VIEWED FROM THE FWD BILGE, IS CRACKED AT STATION 635, LBL 50.SDR KO0R201506020065Seat Track · crackedMAIN DECK SEAT TRACK, AS VIEWED FROM THE FWD BILGE, IS CRACKED AT STATION 635, LBL 10.SDR KO0R201506020064Seat Track · crackedMAIN DECK SEAT TRACK, AS VIEWED FROM THE FWD BILGE, IS CRACKED AT STATION 635 AT LBL 30.SDR KO0R201506020063Seat Track · crackedMAIN DECK SEAT TRACK, AS VIEWED FROM THE FWD BILGE, IS CRACKED AT STATION 635 AT RBL 10.
Back to N546JN