N903AN
Service difficulty reports · 281
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 = 'N903AN' 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 = 'N903AN' 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 AALA200802607Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 23. REMOVED CORROSION AND REPAIRED IN ACCORDANCE WITH SRM 53-70-51 AND 53-00-51 2R.SDR AALA200802606Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 17. REMOVED CORROSION AND REPAIRED IN ACCORDANCE WITH SRM 53 70 51 AND 53 00 51 2R.SDR AALA200802605Floorbeam · corrodedCORROSION FOUND ON AFT GALLEY AREA FLOORBEAM AROUND NUT CLIP HOLES ON UPPER FLANGE. AREA OF DISCREPANCY IS 1 INCH BY 45 INCHES. CUT OFF TOP OF BEAM FROM RIGHT BUTTLINE 6 TO LEFT OUTBOARD END. INSTALLED T CAP REPAIR IN ACCORDANCE WITH SRM 53-70-51.SDR AALA200802604Frame · crackedCRACK FOUND ON FRAME AT RIGHT STATION 727B BETWEEN STRINGERS 8 AND 9. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802600Frame · crackedCRACK FOUND ON FRAME AT RIGHT STATION 480 BETWEEN STRINGER 8 AND 9. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802599Frame · crackedCRACK FOUND ON FRAME AT RIGHT STATION 440 BETWEEN STRINGERS 8 AND 9. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802598Frame · crackedCRACK FOUND ON FRAME AT RIGHT STATION 400 BETWEEN STRINGER 8 AND 9. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802597Frame · crackedCRACK FOUND ON FRAME AT RIGHT STATION 380 AND STRINGER 8. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802596Frame · crackedCRACK FOUND ON FRAME AT LEFT STATION 867 BETWEEN STRINGER 8 AND 9. INSTALLED DOUBLER REPAIR PER ECO J1159AA.SDR AALA200802595Frame · crackedCRACK FOUND ON FRAME AT STATION 500A AND LEFT STRINGER 8. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802594Frame · crackedCRACK FOUND ON FRAME AT LEFT STRINGER AT STATION 480. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802593Frame · crackedCRACK FOUND ON FRAME AT LEFT STRINGER AT STATION 400. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO J1159AA.SDR AALA200802592Frame · crackedCRACK FOUND ON FRAME AT LEFT STRINGER 8. INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH ECO 1159AA.SDR AALA200802486Trunnion · corrodedRT MLG TRUNNION FITTING CORRODED AT UPPER INBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .127 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR USAA200802485Trunnion · corrodedTUL LT MLG TRUNNION FITTING CORRODED AT LOWER OTBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .042 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED, AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR AALA200802484Trunnion · corrodedLT MLG TRUNNION FITTING CORRODED AT LOWER INBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .084 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED, AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR AALA200802483Trunnion · corrodedRT MLG TRUNNION FITTING CORRODED AT UPPER OTBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .107 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED AND INSTALLED NEW BUSHING PER SRM 57 20-90-R2-2.SDR AALA200802482Trunnion · corrodedTUL RT MLG TRUNNION FITTING CORRODED AT LOWER OTBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .142 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED, AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR AALA200802481Trunnion · corrodedTUL LT MLG TRUNNION FITTING CORRODED AT UPPER INBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .119 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED, AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR AALA200802480Trunnion · corrodedTUL RT MLG TRUNNION FITTING CORRODED AT LOWER INBD HOLE OUTER FACE. AREA OF DISCREPANCY IS 2 INCHES BY 2 INCHES WITH A .120 INCH DEPTH. REMOVED CORROSION, TREATED, PRIMED, AND INSTALLED NEW BUSHING PER SRM 57-20-90-R2-2.SDR AALA200802613Skin · bulgedFOUND AFT ENTRY DOOR OUTER SKIN LOWER FORWARD CORNER BULGED OUT. AREA OF DISCREPANCY WAS 1.5 INCHES BY 2 INCHES. REMOVED DAMAGED AREA AND INSTALLED DOUBLER REPAIR IN ACCORDANCE WITH SRM 52 00 01 2R.SDR AALA200802601Trunnion · corrodedCORROSION FOUND ON LEFT FORWARD MAIN LANDING GEAR TRUNNION BUSHINGS. DEPTH OF DISCREPANCY IS .076 INCH. REPAIRED AREA AND INSTALLED NEW BUSHINGS IN ACCORDANCE WITH SRM 57-20-90-R22.SDR AALA200802603Trunnion · corrodedCORROSION FOUND ON LEFT MAIN LANDING GEAR TRUNNION AT UPPER OUTBOARD HOLE OUTER FACE. AREA OF DISCREPANCY IS .076 BY 3 INCHES DIAMETER WITH A DEPTH OF .076. REPAIRED FASTENER HOLES IN ACCORDANCE WITH SRM 57-20-90-R22.SDR AALA200802602Intercostal · crackedCRACK FOUND AT CLIP NUT HOLES ON INTERCOSTAL AT STATION 294.5 AND BUTTLINE 0. AREA OF DISCREPANCY IS 1 INCH BY 1 INCH. CRACK LENGTH IS .5. REPLACED INTERCOSTAL AT STATION 277 TO 294.5 IN ACCORDANCE WITH SRM 53 10 00.SDR AALA200800798Battery Pack · inoperativeMIA - EMERGENCY EXIT SIGN LIGHT AT SEAT 13A INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGN LIGHT AT SEAT 13A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071795Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT RIGHT MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RIGHT MID COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061075Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 13D OVERHEAD BIN INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 13D OVERHEAD BIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061076Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 18D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061074Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 7D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030493Video Display · inoperativeEN ROUTE ORD-LAX, SMOKE WAS COMING OUT OF THE FORWARD CABIN VIDEO MONITOR AND CONTROL BOX. THE SMOKE STOPPED AFTER THE CIRCUIT BREAKERS WERE PULLED. THE VIDEO SYSTEM WAS TURNED OFF IMMEDIATELY. LANDED LAX WITHOUT INCIDENT. REPLACED FORWARD LEFT VIDEO MONITSDR AALA20012047Connector · disconnectedORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 35D INOPERATIVE. RE-CONNECTED EMERGENCY EXIT LIGHT CONNECTOR AT SEAT 25D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N903AN