N8605E
Service difficulty reports · 194
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 = 'N8605E' 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 = 'N8605E' 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 SWAA2018031920519Glowstrip · inoperativeLT AFT PHOTOLUMINESCENT STRIPS INOP. R&R STRIP PER MM.SDR SWAA2018031920494Light · inoperativeRIGHT EMERGENCY LIGHT STRIPS WERE INOPERATIVE. R & R THE LIGHT STRIP IAW MM.SDR SWAA2022020444087Skin · delaminatedL/H WING INTERNAL SKIN @ AFT INSPECTION CAVITY APPROX 24' FROM ATTACH POINT INNER SKIN HAS MATERIAL DISBONDING / ACCOMPLISHED REPAIR 57EA-04511. NO ADDITIONAL DAMGE NOTED.AMT 24651SDR SWAA2017111517834Cover · detachedMID CABIN EMERGENCY EXIT SIGN LIGHT LENS FELL OFF. INSTALLED THE LENS IAW SIP.SDR SWAA2022020244089Seal · crackedLH HORIZONTAL UPPER FWD SLIDER IS CRACKED / REMVOED AND REPLACED L/H HORIZONTAL STAB FWD UPPER SLIDER SEAL PER AMM 53-31-31SDR SWAA2022020244090Seal · crackedRH HORIZONTAL STAB UPPER FWD SLIDER IS CRACKED / REMOVED AND REPLACED R/H HORIZONTAL STAB UPPER FWD SLIDER SEAL PER AMM 53-31-31SDR SWAA2016111009588Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01668. R & R THE BATTERY IAW AMM.SDR SWAA2016111009553Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY IAW AMM.SDR SWAA2016110709478Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIP OUT OF POSITION. REPOSITIONED SLIDE IAW SRM & MT.SDR SWAA2016061052723Cover · brokenNR 1 GALLEY LOWER OTBD EMERGENCY EXIT LIGHT COVER BROKEN. R & R LIGHT ASSY IAW AMM.SDR SWAA2016041850991Plate · dirtyR2 DOOR EMER EVAC SLIDE GUIDE ARM PLATES DIRTY. CLEANED PLATE IAW AMM.SDR SWAA2016031849991Lens · brokenL1 DOOR EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2015122247363Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 27 ABC. R & R LENS IAW MM.SDR SWAA2015122247358Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 16 ABC. R & R LENS IAW MM.SDR SWAA2015122247357Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 18 DEF. R & R LENS IAW MM.SDR SWAA2015122247356Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 19 ABC. R & R LENS IAW MM.SDR SWAA2015122247355Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 21 DEF. R & R LENS IAW MM.SDR SWAA2015122247354Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 22 ABC. R & R LENS IAW MM.SDR SWAA2015122247353Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 23 ABC. R & R LENS IAW MM.SDR SWAA2015122247352Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT 25 DEF. R & R LENS IAW MM.SDR SWAA2015122147315Light · crackedFORWARD LT EMERGENCY LIGHT STRIP CRACKED. R & R EMERGENCY LIGHT IAW MM.SDR SWAA2015122147314Housing · looseCABIN OVERHEAD AISLE EMERGENCY LIGHT ASSEMBLY FOR EMERGENCY EXIT WINDOWS NOT SECURE. SECURED LIGHT ASSEMBLY IAW MM.SDR SWAA2015122147312Light · crackedFORWARD RT EMERGENCY LIGHT STRIP CRACKED. R & R EMERGENCY LIGHT IAW MM.SDR SWAA2015122147311Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 27 ABC. R & R LENS IAW MM.SDR SWAA2015122147310Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 16 ABC. R & R LENS IAW MM.SDR SWAA2015122147309Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 18 DEF. R & R LENS IAW MM.SDR SWAA2015122147308Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 19 ABC. R & R LENS IAW MM.SDR SWAA2015122147307Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 21 DEF. R &R LENS IAW MM.SDR SWAA2015122147306Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 23 ABC. R & R LENS IAW MM.SDR SWAA2015122147305Lens · crackedCABIN EMERGENCY LIGHT LENS CRACKED AT ROW 25 DEF. R & R LENS IAW MM.SDR SWAA2015122147299Lens · crackedEMERGENCY LIGHT LENS CRACKED AT OVERHEAD BIN 6 DEF. R & R LENS IAW MM.SDR SWAA2015122147292Lens · crackedEMERGENCY LIGHT LENS CRACKED AT OVERHEAD BIN 10 DEF. R & R LENS IAW MM.SDR SWAA2015072242113Lens · missingLEFT EMER AISLE LIGHT LENS MISSING AT ROW 5. INSTALLED LENS IAW MM.SDR SWAA2015052139912Lens · missingRIGHT EMER EXIT LIGHT LENS MISSING AT ROW 14. INSTALLED LENS IAW MM.SDR SWAA2015041338471Sign · looseOVERWING EXIT SIGN LOOSE. R & R SIGN IAW AMM.SDR SWAA2015040938328Sign · looseOVERWING EXIT SIGN LOOSE. R & R SIGN IAW AMM.SDR SWAA2015022536880Cover · missingLEFT EMER EXIT LIGHT COVER MISSING AT ROW 8. INSTALLED COVER IAW MM.SDR SWAA2014060528725Latch · looseL1 DOOR EMER EVAC SLIDE GIRT BAR LATCH LOOSE. SECURED LATCH ASSEMBLY IAW MT.SDR SWAA2014060228558Latch · looseL1 DOOR EMER EVAC SLIDE GIRT BAR LATCH LOOSE. R & R LATCH ASSEMBLY IAW MT.SDR SWAA2013112022609Lens · crackedOVERHEAD EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 8 & ROW 14. REPAIRED LENS IAW MM.SDR SWAA2013111822468Lens · crackedOVERHEAD EMERGENCY LIGHT LENSES CRACKED BETWEEN ROW 8 & ROW 14. R & R LENS IAW MM.SDR SWAA2013102821450Cover · looseFWD EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2013082019368Lens · looseOVERHEAD AISLE EMERGENCY EXIT SIGN LENSES LOOSE. SECURED LENS IAW MM.SDR SWAA2013061217114Lens · looseFWD RT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.
Back to N8605E