N967AN
Service difficulty reports · 253
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 = 'N967AN' 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 = 'N967AN' 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 AALA2019082329080Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FORWARD BAFFLE ATTACHMENT ANGLE CRACKED AT BS 500F AND LBL 25 AT S25L. REPLACED ATTACHMENT ANGLE PER SRM 51-40-02.SDR AALA2019082329079Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CENTER WING REAR SPAR LEFT HAND VERTICAL PRESSURE DECK ATTACH ANGLE CRACKED AT BS 663 AND LBL 33. REPAIRED ATTACH ANGLE PER EA 296768.SDR AALA2019082629073Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT BAFFLE ATTACHMENT CLIP ANGLE CRACKED AT BS 500F AND RBL 25. REPLACED ATTACHMENT CLIP ANGLE PER BOEING DRAWING 143A7505.SDR AALA2019082629074Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT BAFFLE ATTACHMENT CLIP ANGLE CRACKED AT BS 500G AND RBL 25. REPLACED ATTACHMENT CLIP ANGLE PER BOEING DRAWING 143A7505.SDR AALA2019082629071Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 537 AND RBL 12. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019082629070Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 537 AND RBL 12. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019082629069Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND OUT BOARD FLOOR SUPPORT AT BS 537. REPLACED FLOOR SUPPORT PER AARD 51-00-05.SDR AALA2019082629064Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 847 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER 51-00-05-1.SDR AALA2019082629061Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 887 AND S27L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019082629067Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 847 AND S26L. REPLACED STRINGER CLIP PER EA 296985.SDR AALA2019082629065Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 867 AND S26L. REPLACED STRINGER CLIP PER EA 296985.SDR AALA2019082629062Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 827 AND S27L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019082629055Stringer Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER SPLICE AT BS 887 AND S27L. REPLACED STRINGER SPLICE PER AARD 51-00-05-1.SDR AALA2019082629056Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 827 AND S26L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA201908239002Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 887 AND S26L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019082329027Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE AT BS 500E AND RBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA2019082629047Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER CLIP AT BS 807 AND S26L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019082629066Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN UNDER PHONE ANTENNA BETWEEN BS 6500A AND BS 500B, BETWEEN S27L AND S27R. REPAIRED SKIN PER EA 296716.SDR AALA2019082629057Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 847 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA2019082629035Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER ATTACHMENT ANGLE CLIP AT BS 907 AND S27L. REPLACED ATTAMENT ANGLE CLIP PER SRM 51-40-02.SDR AALA2019082629059Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED VERTICAL PRESSURE DECK WEB AT BS 663 BETWEEN RBL 40 AND RBL 45.64. REPAIRED VERTICAL PRESSURE DECK WEB PER SRM 57-10-10-2R-3.SDR AALA201907259012Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 1. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201907259011Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT BS 284 AND BL 0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA2019082329025Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIB ON THE RIGHT HAND HORIZONTAL STABILIZER AT STATION 92.75. REPLACED RIB PER AARD 51-00-05-1.SDR AALA2019082629053Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER BETWEEN BS 820 AND BS 880 AT S27L. REPAIRED STRINGER PER 51-00-05-1.SDR AALA2019082629068Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER AT BS 809 AND S27L. REPAIRED STRINGER PER EA 296632.SDR AALA2019082629058Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 827 AND S25L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA2019082629051Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 827 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA2019082629050Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 807 BETWEEN S25L AND S26L. REPLACED SHEAR TIE PER AARD 53-00-05-1 AND EA 296559.SDR AALA2019082629049Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 807 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA2019082629048Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER BETWEEN BS 807 AND BS 887 AT S26L. REPLACED STRINGER PER SRM 53-00-03.SDR AALA2019082629046Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ATTACH CLIP AT BS 847 AND S27L. REPLACED ATTACH CLIP PER SRM 53-00-53.SDR AALA2019082629041Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 867 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER SRM 51-40-02.SDR AALA201908239004Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 867 AND BS 887 AT LBL 17. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019082329028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 294.5 AND RBL 55. REPLACED FLOOR SUPPORT AARD 51-00-05-1.SDR AALA201907229058Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT BS 345 AND LBL 45. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA2019082629052Splice Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INNER FUSELAGE SKIN BUTT SPLICE PLATE AT BS 887 AND S26L. REPAIRED BUTT SPLICE PLATE PER EA 296850.SDR AALA2019082629039Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 440 AND BS 456 AT S25R. REPLACED SILL WEB PER AARD 51-00-05.SDR AALA2019082329084Failsafe · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FORWARD FRAME FAIL SAFE STRAP AT BS 440 BETWEEN RBL 28 AND RBL 33. REPAIRED FRAME FAIL SAFE STRAP PER EA 296739.SDR AALA2019082329029Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 489 AND BS 495 AT RBL 26. REPLACED WEB PER AARD 51-00-05.SDR AALA2019082629054Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 958 AND RBL 50. REPLACED THE FLOOR SUPPORT PER 51-00-05-1.SDR AALA2019082629072Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 947 AND RBL 51. REPAIRED FLOOR BEAM PER EA 296627.SDR AALA2019082629063Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 950 BETWEEN LBL 27 AND LBL 49. REPLACED FLOOR SUPPORT PER 51-00-05-1.SDR AALA2019082629060Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT 958 AND LBL 28. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA2019082629045Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND LBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629044Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND RBL 11. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629043Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND LBL 12. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629042Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND RBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629040Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD RIGHT HAND DOOR CUT OUT CREASE ANGLE SPLICE AT BS 304 AND RBL 55. REPLACED CREASE ANGLE PER EA 296725 AND AARD 51-00-05-1.SDR AALA2019082629038Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 986.5 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R.
Back to N967AN