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 AALA202301310611Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-LAMPED LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.SDR AALA202301182862Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR SUPPORT UPPER SURFACE HAS CORROSION AT APPROXIMATELY STA 950, RIGHT BUTT LINE 16. DRILLED NEW FLOOR SUPPORT.SDR AALA202301181433Floor Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FLOOR PANEL AT STA 727D+5 TO 727I+5 HAS SURFACE CORROSION. FABRICATED AFT PIT FLOOR PANEL AND REPLACED CORRODED PANEL.SDR AALA202301258353Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN INTERCOSTAL LOCATED AT BS 947.5 AND RBL 24. REPLACED INTERCOSTAL PER SRM 51-40-05 AND DWG 147A5650.SDR AALA202301257975Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR SUPPORT LOCATED AT BS 951 AND RBL 16. REPLACED FLOOR SUPPORT PER SRM 51-40-05 AND DWG 147A5650.SDR AALA202301062895Support Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUTOUT LOWER SILL SUPPORT PLATE LOCATED FROM BS 807 TO BS 847 AND FROM S27R TO S37R. REPLACED SILL SUPPORT PLATE PER SRM 51-40-01 AND DWG 146A8340.SDR AALA202301031610Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FORWARD BULKHEAD SUPPORT ANGLE LOCATED AT BS 727 AND BL 0. REPLACED ANGLE PER DWG BAC144A2600 AND SRM 51-40-02.SDR AALA202301125004Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301123979Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301127351Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINER LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351,SDR AALA202301120840Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301128973Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301187118Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT PIT AFT CORNER SCUFF PLATE CRACKED ALONG THE EDGE. REMOVED AND REPLACED SCUFF PLATE ASSEMBLY.SDR AALA202301186439Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FORWARD FLOOR ANCHOR PLATE CAP STRIP HAS SURFACE CORROSION. REMOVED AND REPLACED SCUFF PLATE.SDR AALA202301183293Anchor Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO AFT FLOOR ANCHOR PLATE CAP STRIP HAS SURFACE CORROSION. REMOVED AND REPLACED SCUFF PLATE.SDR AALA202212226814Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500I AND FROM S26R TO S19R. REPLACED SUPPORT ANGLE PER SRM 51-40-02 AND DWG 143A7902.SDR AALA202212165787Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER SUPPORT ANGLE LOCATED AT BS 500I FROM S26L TO S26R. REPLACED SUPPORT ANGLE PER SRM 51-40-02 AND DWG 143A7902.SDR AALA202212229381Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947 AND RBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202212227442Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND LBL 31. REPLACED INTERCOSTAL PER SRM 51-00-04-0G.SDR AALA202212220764Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND RBL 31. REPLACED INTERCOSTAL PER SRM 51-00-04-0G.SDR AALA202212169387Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN PRESSURE BULKHEAD LOWER INTERCOSTAL LOCATED AT BS 1016 AND LBL 20. REPAIRED INTERCOSTAL PER SRM 53-80-08-1A-1.SDR AALA202301187253Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241RF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183214Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242PF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188082Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242MF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301181736Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242GF HAS DAMAGE TO TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183694Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242FF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301180952Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241VF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186191Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241SF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186986Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 241QF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301181426Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232SF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188590Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231ZF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301187939Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231GF HAS EDGE DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186247Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 242JF HAS DAMAGE ON THE TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188608Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232FF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301183557Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232EF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188035Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 232CF HAS DAMAGE TO TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186667Floor Panel · puncturedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231XF HAS MULTIPLE PUNCTURES IN TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301187426Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231NF HAS DAMAGE ON TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301188549Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231LF HAS DAMAGE ON TOP SKIN OF PANEL. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301189703Floor Panel · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN, FLOOR PANEL 231EF HAS DAMAGE TO TOP SKIN. REMOVED AND REPLACED FLOOR PANEL.SDR AALA202301186147Support Bracket · brokenAIRCRAFT IN BASE MAINTENANCE: AFT CARGO, FORWARD BULKHEAD HAS BROKEN SUPPORT BRACKET. REMOVED AND REPLACED SUPPORT BRACKET ON AFT CARGO FORWARD BULKHEAD.SDR AALA202211025573Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVER WING FORWARD EMERGENCY EXIT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP.SDR AALA202210100837Smoke Detector · inoperativeAIRCRAFT WAS GROUNDED (LONG TERM STORAGE): AFT LEFT CARGO BAY SMOKE DETECTOR INOPERATIVE. REPLACED CARGO BAY SMOKE DETECTOR PER AMM 26-16-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202002069003Amplifier · failedAIRCRAFT WAS GROUNDED: CAPTAINS COMMUNICATION COMPLETELY INOPERATIVE USING ANY HEADSET. INTERCOM LOUD BUZZ. ATC-VHF LOUD BUZZ MISSED ATC CALLS INCOMING TWICE. HANDSET COMMUNICATION SEEMS TO WORK FINE. AFTER SWITCHING HEADSETS TO PERSONAL SINGLE PLUG HEADSET SDR AALA201905149003Warning System · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS STARTED DESENT FROM FL 380 GOT AUTO FAIL LIGHT ON PRESSURIZATION ALT LIGHT ILLUMINATION SHORTLEY AFTER ALT LIGHT WENT OUT CONTINUED DESENT TO 10000 CABIN PRESSURE STAYED AROUD 9000'. MAINTENANCE PERFORMED DCPC BITE TEST IASDR AALA201904259003Pin · shearedAIRCRAFT NOT GROUNDED: MAINTENANCE FOUND THE FWD ENTRY DOOR LEFT SIDE GUIDE ARM MOUNTING PIN SHEARED, (GUST LOCK PIN). MAINTENANCE REPLACED PIN AND HARDWARE IAW AMM 52-11-21. OPS CHECK GOOD.SDR AALA201902284006Seal · damagedPILOT REPORTS THAT THERE WAS A LOUD SQUEAL COMING FROM THE L1 DOOR ON CLIMB OUT. FOUND THE DOOR SEAL WAS DAMAGED. REPAIRED IAW RD 52-00-00-2, REPAIR 2. PRESSURIZED AIRCRAFT WITH NO LEAKS NOTED.SDR AALA201902087006Stringer · corrodedCORROSION FOUND ON THE STRINGER 24L AT BS 887. REPAIRED THE STRINGER IAW SRM53-00-03-2R-1, AND EA 289771.SDR AALA201902087005Stringer · crackedCRACKED STRINGER 24L BETWEEN BS 888 AND 889. REPAIRED THE STRINGER IAW SRM 53-00-03-2R-1, AND EA 289809.SDR AALA201902079017Frame · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FRAME FLANGE AT BS 907 BETWEEN S23L AND S24L. REPAIRED FRAME PER EA 289535.
Back to N903AN