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 AALA20121124014Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 25 AND 26 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124013Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 24 AND 25 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124012Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 987 BETWEEN STRINGERS 24 AND 25 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124011Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 947 BETWEEN STRINGERS 24 AND 25 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124010Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 947 BETWEEN STRINGERS 27 LEFT AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124009Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 987 BETWEEN STRINGERS 27 LEFT AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124008Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 27 LEFT AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124007Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 26 AND 27 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124006Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 987 BETWEEN STRINGERS 26 AND 27 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124005Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 907 TO 947 BETWEEN STRINGERS 26 AND 27 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124004Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 888 TO 907 BETWEEN STRINGERS 26 AND 27 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121123002Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 26 AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER E B737-53-027217.SDR AALA20121022001Connector · disconnectedSEAT ROW 17DEF EMERGENCY EGRESS LIGHT INOPERATIVE. RECONNECTED CONNECTOR AT POWER SUPPLY TO SEAT. OPS CHECK NORMAL.SDR AALA20120606013Light · missingEMERGENCY AISLE LIGHT AT SEAT 13D MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY AISLE LIGHT AT SEAT 13D. OPS CHECK NORMAL.SDR AALA20120605009Lens · missingEMERGENCY AISLE LIGHT AT SEAT 13D MISSING LENS COVER. REPLACED RED LENS COVER FOR EMERGENCY AISLE LIGHT AT SEAT 13D. OPS CHECK NORMAL.SDR AALA20110424LAX02Anti-Skid Valve · defectiveLAX - INFLIGHT DFW-SNA. CREW REPORTED ANTISKID LIGHT AND AUTO BRAKE LIGHT ILLUMINATED. QRM FOLLOWED AND AUTOBRAKE SELECTOR TURNED OFF. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 2 ANTI-SKISDR AALA20101023TUL04Indicator · inoperativePBI - CREW REPORTED INTERGRATED FLIGHT DISPLAY CIRCUIT BREAKER POPPED. FLIGHT RETURNED PBI LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTERGRATED STANDBY/AIRSPEED ALTIMETER INDICATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101011TUL02Beam · damagedAFT CARGO DOOR NUMBER 4 BEAM IS BENT, CRACKED, AND TORN IN RADIUS AT AFT END. REPLACED NUMBER 4 BEAM PER ESO60651.SDR AALA20101008TUL10Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 987 RIGHT BUTTLINE 43. INSTALLED NEW T-CAP REPAIR ANGLE, DOUBLERS, TRIPLERS, STRAP AND INSTALLED REPAIR ANGLES ON INTERCOSTAL AND RE-INSTALLED INTERCOSTAL PER SRM 53-70-51-2R.SDR AALA20101009TUL09Skin · damagedAFT CARGO DOOR EXTERIOR SKIN HAS A SHALLOW DENT AND EXTERIOR SKIN IS SCRATCHED ON LOWER HALF. REMOVED DENTED AND SCRATCHED SKIN AND INSTALLED NEW EXTERIOR SKIN PER ESO 60651.SDR AALA20100121TUL04Skin · dentedFUSELAGE DENT ABOVE LEFT NUMBER ONE DOOR COMMON TO STATION 325 TO 326, STRINGER 3LEFT. SKIN REPAIR DOUBLER INSTALLED PER SRM 53-00-01-2R 3.SDR AALA20091113TUL01Web · corrodedCORROSION ON PAD AREA OF WEB FOR RIGHT, LEFT, AND AFT FUEL BOOST PUMPS AT GROUND STRAP ATTACH POINTS. REMOVED CORROSION, REPAIRED WEBS PER EA B737-57-008053.SDR AALA2009080800001Battery Pack · failedMIA - EMERGENCY BATTERY PACK AT LOCATION M1695 FAILED. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LOCATION M1695.SDR AALA2009051400002Bypass Switch · burnedMIA - RIGHT FILTER BYPASS INDICATION. EMERGENCY DECLARED, RETURNED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND THE FUEL BYPASS SWITCH BURNT. REPLACED THE FUEL BYPASS SWITCH AND THE RIGHT ENGINE FUEL FILTER. SYSTEM GROUND CHECK NORMAL OPERATSDR AALA2009030900566Lamp · burned outMIA - EMERGENCY LIGHT AT SEAT 10D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 10D.SDR AALA2009030400002Battery Pack · dischargedSJU - EMERGENCY AISLE LIGHTS BETWEEN 19ABC AND 25ABC ON WITH EMERGENCY LIGHT SWITCH ON ARMED. REPLACED BATTERY PACK FOR EMERGENCY AISLE LIGHTS BETWEEN 19ABC AND 25ABC.SDR AALA2009030400001Battery Pack · dischargedSJU - DURING CLIMBOUT EMERGENCY EXIT LIGHTS WERE ILLUMINATED IN THE AFT AREA AND OVER THE LEFT WING. REPLACED BATTERY FOR EMERGENCY LIGHTS IN THE AFT AREA AN OVER THE LEFT WING.SDR AALA200810005Floor Support · corrodedCORROSION ON FLOOR SUPPORT ANGLE RIGHT SIDE STATION 767 TO 787 ABOVE STRINGER 25. REPLACED FLOOR SUPPORT ANGLE PER ESO 61000 DATED 10/02/2008.SDR AALA200810004Floorbeam · corrodedCORROSION AND TOOLING MARKS TOP OF 328 BEAM. REPAIRED FLOORBEAM PER ESO 61000 DATED 10-02-2008.SDR AALA200802614Intercostal · crackedFOUND CRACK ON INTERCOSTAL AT NUT PLATE HOLE AT STATION 320. REPLACED INTERCOSTAL.SDR AALA200802610Web · corrodedCORROSION FOUND ON UPPER SURFACE OF WEB AT STATION 988. INSTALLED DOUBLER REPAIR TO WEB IN ACCORDANCE WITH SRM 51-70-13.SDR AALA200802612Panel · corrodedCORROSION FOUND IN FOUR PLACES ON AFT CARGO FLOORBOARD SUPPORT SIDEWALL TRANSITION PANEL BETWEEN LEFT STATIONS 787 AND 827. AREA OF DISCREPANCY WAS 4 INCHES BY 40 INCHES. REPLACED FLOORBOARD SUPPORT TRANSITION PANEL.SDR AALA200802609Web · corrodedCORROSION FOUND ON WEB AND FLOOR SUPPORT IN AFT GALLEY. AREA OF DISCREPANCY IS 2 INCHES BY 4 INCHES. REPAIRED WEB AND REPLACED FLOOR SUPPORT IN ACCORDANCE WITH SRM 51-70-13 2R.SDR AALA200802591Web · corrodedFLOOR STRUCTURE WEB FOUND CORRODED. AREA OF DISCREPANCY IS 1 INCH BY 1 INCH. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 51-70-13-2R.SDR AALA200802500Floorbeam · corrodedCORROSION ON FLOORBEAM AT CLIP NUT HOLE BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802499Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802498Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802497Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802496Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802495Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802494Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802493Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802492Intercostal · corrodedCORROSION ON UPPER SURFACE OF INTERCOSTAL BEYOND LIMITS. REPLACED INTERCOSTAL PER SRM 51-10-02-OG.SDR AALA200802491Floor Support · corrodedTUL CORROSION ON FLOOR SUPPORT IN AFT CARGO BEYOND LIMITS. AREA OF DISCREPANCY IS 4 INCHES BY 1 INCH. REPLACED FLOOR SUPPORT PER SRM 53-00-53.SDR AALA200802490Floor Support · corrodedCORROSION ON FLOOR SUPPORT IN AFT CARGO BEYOND LIMITS. AREA OF DISCREPANCY IS 10 INCHES BY 1 INCH. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA200802489Floor Support · corrodedCORROSION ON FLOOR SUPPORT IN AFT CARGO BEYOND LIMITS. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA200802488Intercostal · corrodedCORROSION ON TOP OF INTERCOSTAL. REPAIRED PER SRM 51-10-02-OG.SDR AALA200802487Angle · corrodedCREASE ANGLE AT FORWARD SERVICE DOOR HAS LARGE AREA OF CORROSION. REPAIRED PER SRM 51-70-11-02.SDR AALA200802611Cargo Track · corrodedCORROSION FOUND ON AFT CARGO TRACK AT STATION 787 RIGHT BUTTLINE 13.84. SPLICED IN NEW CARGO TRACK SECTION IN ACCORDANCE WITH SRM 53-00-53-22 REPAIR 3.SDR AALA200802608Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 29.5. REMOVED CORROSION AND REPAIRED PER SRM 53-70-51 AND 53-00-51 2R.
Back to N903AN