N201LV
Service difficulty reports · 350
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 = 'N201LV' 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 = 'N201LV' 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 SWAA2013011611474Door Frame · crackedCRACK IN FRAME AT STA 296, RBL 54, WL 209. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013011411392Floorbeam · corrodedCORROSION ON 328 FLOORBEAM AT STA 328, RBL 57 WL 208. REPAIRED FLOORBEAM AT STA 328 RBL 57 WL 208 PER SRM 53-10-51-2R7.SDR SWAA2013011411391Intercostal · crackedUPPER FLANGE OF INTERCOSTAL IS CRACKED AT STA 284, RBL 1, WL 208. REMOVED AND REPLACED UPPER FLANGE OF INTERCOSTAL AT STA 284, RBL 1, WL 208 IAW SRM 51-40-02-0G-0.SDR SWAA2013010711154Crease Beam · corrodedCORROSION ON I/B CORD OF RIGHT CREASE BEAM CORD STA 955-986 RBL 51 WL 208. REPAIRED BEAM PER SRM MM.SDR SWAA2013010311068Support · corrodedFLOOR TO SIDEWALL SUPPORT HAS CORROSION ON UPPER SURFACE AT NUT PLATE HOLES AT BS 500A+2, 500A+16, RBL 23. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT BS 500A TO BS 500D IAW SRM 51-40-02-0G-0.SDR SWAA2013010711153Floor Panel · corrodedAFT CARGO BAY FLOOR PANEL 140CF HAS CORROSION AT THE O/B AFT EDGE. REMOVED & REPLACED ACB FLOOR PANEL 140CF PER DWG 453A2610 & SRM 51-40-05 & SRM 53-00-53-1A-1 STEP 5.SDR SWAA2013011011338Cargo Track · corrodedCORROSION ON CARGO FLOOR TRACK BS 795-842 RBL 14 WL 155. REMOVED AND REPLACED TRACK PER EA.SDR SWAA2013010911273Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT BS 847-867 RBL 21 WL 155. REMOVED AND REPLACED SUPPORT IAW SRM AND DWG.SDR SWAA2013010811250Support · corrodedCORROSION CORROSION ON FLOOR TO SIDEWALL SUPPORT BS 767-787 RBL 21 WL 155. SIDEWALL SUPPORT BS 767-787 RBL 21 WL 155 WAS REPLACED WITH NEW PER SRM 51-40-05, SRM 51-40-02.SDR SWAA2013010711152Floor Support · corrodedLEFT FLOOR SUPPORT CORRODED BETWEEN BS 500B+7 TO BS 500D. REMOVED AND REPLACED SUPPORT IAW SRM.SDR SWAA2013010411121Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT BS 727+12-BS 807 LBL 21, WL 155. REMOVED AND REPLACED SUPPORT PER SRM.SDR SWAA2013010411120Threshold · corrodedDOOR SURROUND, AT THE THRESHOLD AREA ON UPPER SURFACE HAS CORROSION AT BS 451 TO BS 480, RBL 28. REMOVED AND REPLACED THRESHOLD AT BS 451-BS 480 RBL 28 IAW SRM 51-40-02, SRM 51-40-05 & SRM 53-30-15-01-1.SDR SWAA2013010311067Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT, BS 727+12-767 RBL 21 WL 155. REMOVED AND REPLACED DAMAGED SIDEWALL SUPPORT FROM BS 727+4 - 767, RBL 21 PER DWG AND SRM 51-40-02.SDR SWAA2012102308770Battery Pack · failedFORWARD EMERGENCY BATTERY FAILED CAPACITY FUNCTION CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2012102308769Battery Pack · failedAFT EMERGENCY BATTERY FAILED CAPACITY FUNCTION CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2012101708583Rib · crackedLEFT HORIZONTAL STABILIZER RIB CRACKED AT STA 92.7 FWD LOWER CORNER. REPAIRED RIB IAW EA AND ER.SDR SWAA2012101208463Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED BETWEEN STA 92.7 TO STA 101.9. REPAIRED SKIN IAW SRM.SDR SWAA2012101108419Stiffener · crackedRIGHT HORIZONTAL STABILIZER RIB VERTICAL STIFFENERS CRACKED AT STA 92.7. REPAIRED STIFFENERS IAW SPM.SDR SWAA2012101708582Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SURFACE INSPAR SKIN CRACKED AT STA 41.5. REPAIRED SKIN IAW SRM.SDR SWAA2012101208462Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SURFACE INSPAR SKIN CRACKED 69" O/B OF ROOT. REPAIRED SKIN PER SRM.SDR SWAA112958Lens · missingLT OVERWING LOWER EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA112355Light · inoperativeEEPLS INOP AT ROW 1. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA112157Lens · looseFWD EEPLS LENS LOOSE. SECURED LENS PER MM.SDR SWAA112001Lens · looseFWD EEPLS LENS LOOSE. SECURED LENS PER MM.SDR SWAA111954Cap · missingDURING SCHEDULED CV CHECK, FOUND FWD EEPLS END CAP MISSING. INSTALLED END CAP PER MM.SDR SWAA111578Lens · missingROW 4 EMERGENCY EXIT STRIP LENS MISSING. INSTALLED LENS PER MM.SDR SWAA111353Cover · missingFWD EELPS COVER MISSING AT ROW 6. INSTALLED COVER PER MM.SDR SWAA111352Cover · missingFWD EELPS COVER MISSING AT ROW 1. INSTALLED COVER PER MM.SDR SWAA110492Pressure Panel · crackedDURING SCHEDULED 6Y CHECK, FOUND VERTICAL PRESSURE WEB CRACKED AT BS 663, RBL 43. REPAIRED WEB PER EA.SDR SWAA110342Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, RBL 15. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA110341Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, RBL 7. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA110340Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, LBL 41.5. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA110339Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, LBL 32. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA110338Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, LBL 15. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA110337Fitting · crackedDURING SCHEDULED 6Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, LBL 7. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA100115Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 147.90. REPAIRED SKIN PER SRM.SDR SWAA094877Battery Pack · failedDURING SCHEDULED HC1 CHECK, EMERGENCY EXIT LIGHT BATTERY PACK FAILED CYCLE TEST. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA086905Battery Pack · failedDURING SCHEDULED HC2 CHECK, RT BATTERY PACK FAILED CAPACITY TEST. REPLACED BATTERY PACK PER MM.SDR SWAA086904Battery Pack · failedDURING SCHEDULED HC2 CHECK, LT BATTERY PACK FAILED CAPACITY TEST. REPLACED BATTERY PACK PER MM.SDR SWAA086903Cover · crackedDURING SCHEDULED HC2 CHECK, FOUND RT EEPLS COVER CRACKED. REMOVED AND REPLACED COVER PER MM.SDR SWAA086902Cover · crackedDURING SCHEDULED HC2 CHECK, FOUND LT EEPLS COVER CRACKED. REMOVED AND REPLACED COVER PER MM.SDR SWAA086901Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND LT OVERWING EMERGENCY EXIT HATCH LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA085083Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND RT OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084373Lens · crackedEEPLS LENS CRACKED AT ROW 2 ABC. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA083797Handle · dirtyMLG & NLG UNSAFE LIGHTS INDICATION. RECYCLED GEAR HANDLE AND GOT 3 GREEN LIGHTS. C/W BITE CK AND CLEANED GEAR HANDLE. OPS CHECK GOOD.SDR SWAA081906Lens · crackedDURING SCHEDULED HC1 CHECK, FOUND EEPLS LENS CRACKED AT ROW 2 ABC. REMOVED AND REPLACED LENS PER MM.SDR SWAA063288Cover · missingDURING SCHEDULED MV2 CHECK, FOUND EEPLS LIGHT COVER MISSING AT ROW 1 ABC. INSTALLED EEPLS COVER PER MM.SDR SWAA063005Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062981Cover · looseEEPLS LIGHT COVER LOOSE AT ROW 1 ABC. REMOVED AND REPLACED EEPLS LIGHT COVER PER MM.SDR SWAA061982Lens · missingEEPLS LIGHT LENS MISSING AT ROW 1 ABC. INSTALLED LIGHT LENS PER MM.
Back to N201LV