N264LV
Service difficulty reports · 274
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 = 'N264LV' 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 = 'N264LV' 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 SWAA2022012620783Seal · crackedR/H STABILIZER FORWARD UPPER SLIDING SEAL IS CRACKED. / REMOVED AND REPLACED SLIDING SEAL PER AMM 53-31-31SDR SWAA2017053014014Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017052313921Light · inoperativeEMERGENCY EXIT LIGHT INOP AT ROW 1 ABC. RELAMPED PER MM.SDR SWAA2017041813164Sign · brokenL2 DOOR LOWER EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR SWAA2017032112669Battery Pack · inoperativeEMERGENCY BATTERY PACK M1668 INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016120810301Glowstrip · missingLT PHOTO LUMINESCENT STRIP MISSING BLUE INTERNAL STRIP AT ROW 21. R&R STRIP PER AMM.SDR SWAA2016120810300Glowstrip · discoloredLT PHOTO LUMINESCENT STRIP DISCOLORED AT ROW 21. R&R STRIP PER AMM.SDR SWAA2016120110144Rib · crackedRT HORIZONTAL STABILIZER RIB CRACKED AT STA 92.70, 3RD FROM THE FRONT VERTICAL STIFFENER. REPAIRED RIB PER CCO AND SRM.SDR SWAA2016112910086Rib · crackedRT HORIZONTAL STABILIZER RIB CRACKED AT STAB STA 92.70, 2ND FROM THE FRONT VERTICAL STIFFENER. REPAIRED RIB PER EA.SDR SWAA2016112910085Rib · crackedRT HORIZONTAL STABILIZER RIB CRACKED AT STAB STA 166.30, 3RD FROM THE FRONT VERTICAL STIFFENER. REPAIRED RIB PER EA.SDR SWAA2016120110145Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, LBL 1. R&R INTERCOSTAL PER SRM.SDR SWAA2016101108587Trunnion · corrodedRT MAIN LANDING GEAR FORWARD TRUNNION LUG FACE FITTING CORRODED. REPAIRED THE FITTING IAW EA.SDR SWAA2016101108586Trunnion · corrodedLEFT MAIN LANDING GEAR FORWARD TRUNNION LUG FACE FITTING CORRODED. REPAIRED THE FITTING PER EA.SDR SWAA2016100308349Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN CRACKED 10" FORWARD OF REAR SPAR ON INBOARD SIDE OF STAB STA 147.90. REPAIRED SKIN PER SRM.SDR SWAA2016100308348Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN CRACKED 33" FORWARD OF REAR SPAR ON INBOARD SIDE OF STAB STA 138.70. REPAIRED SKIN PER SRM.SDR SWAA2016100308347Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN CRACKED 25" FORWARD OF REAR SPAR ON INBOARD SIDE OF STAB STA 138.70. REPAIRED SKIN PER SRM.SDR SWAA2016100308346Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN CRACKED 10" FORWARD OF REAR SPAR ON INBOARD SIDE OF STAB STA 101.90. REPAIRED SKIN PER SRM.SDR SWAA2016100308345Pressure Panel · crackedCENTER WING SECTION REAR SPAR WEB CRACKED AT BS 663, RBL 33.8. REPAIRED WEB PER EA.SDR SWAA2016100308344Pressure Panel · crackedCENTER WING SECTION REAR SPAR WEB CRACKED AT BS 663, RBL 43.3. REPAIRED WEB PER EA.SDR SWAA2016100308343Skin · crackedGROUND POWER RECEPTACLE ACCESS DOOR MATING FLANGE CRACKED. REPAIRED FLANGE PER SRM.SDR SWAA2016010447615Lens · brokenL1 DOOR EXIT LIGHT LENS BROKEN. REPLACED LENS IAW MM.SDR SWAA2015062541110Battery · failedEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R BATTERY IAW MM.SDR SWAA2015062541109Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R & R BATTERY IAW MM.SDR SWAA2015062541108Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. R & R BATTERY IAW MM.SDR SWAA2014122335236Floor Support · crackedFUSELAGE STATION 727B LONGITUDINAL FLOORBEAM CRACKED AT RBL 45. REPAIRED BEAM IAW EA.SDR SWAA2014121635079Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO 360, BL 0. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014123035317Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, LBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2014122335235Floor Support · crackedFUSELAGE STATION 727B LONGITUDINAL FLOORBEAM CRACKED AT LBL 24.75. REPAIRED BEAM IAW EA.SDR SWAA2014122335234Floor Support · crackedFUSELAGE STATION 727B, LONGITUDINAL FLOORBEAM CRACKED AT LBL 45. REPAIRED BEAM IAW EA.SDR SWAA2014121735102Post · crackedNUMBER 1 WINDOW POST CRACKED AT 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2014121635078Scuff Plate · crackedC1 DOOR CUT OUT LOWER AFT CORNER SCUFF PLATE CRACKED. R & R SCUFF PLATE IAW SRM.SDR SWAA2014121635077Scuff Plate · crackedC1 DOOR CUT OUT LOWER FWD CORNER SCUFF PLATE CRACKED. R & R SCUFF PLATE IAW SRM.SDR SWAA2014122335243Skin · crackedFUSELAGE SKIN CRACKED AT STATION 540, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014121635076Pressure Panel · crackedMAIN WW VERTICAL PRESS WEB CRACKED AT BS 663, LBL 43. REPAIRED WEB IAW SRM.SDR SWAA2014031225970Battery Pack · failedAFT GALLEY DOOR EMERGENCY LIGHTS FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM.SDR SWAA2013111322312Housing · damagedMID CABIN OVERHEAD EMERGENCY EXIT SIGN HOUSING DAMAGED. R & R SIGN HOUSING IAW AMM.SDR SWAA2012121410673Skin · crackedMAIN CABIN CENTER TANK UPPER SKIN LBL 6.14" STA 544 4TH FASTENER HOLE FROM FWD HAS A CRACK INDICATION PER HFEC PART 6 51-00-00 FIG 16. REPAIRED SKIN PER EA.SDR SWAA2012111609528Lens · missingROW 5 & 21 EMERGENCY TRACK LIGHT LENS MISSING. REMOVED AND REPLACED PER AMM.SDR SWAA2012100408252Cover · missingFWD EEPLS COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2012100408250Light · inoperativeFWD EEPLS BULB INOP. RELAMPED BULB PER MM.SDR SWAA2012090407254Lens · brokenLEFT EEPLS LENS BROKEN AT ROW 23. REMOVED AND REPLACED LENS PER M/M.SDR SWAA2012090407253Light · inoperativeLEFT EEPLS INOP AT ROW 23. RELAMPED EEPLS PER M/M.SDR SWAA2012090407252Lens · brokenLEFT EEPLS LENS BROKEN AT ROW 6. REMOVED AND REPLACED LENS PER M/M.SDR SWAA2012082706979Sign · brokenOVERHEAD EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012080306428Cover · brokenLEFT EEPLS COVER BROKEN AT ROW 3. REMOVED AND REPLACED COVER PER MM.SDR SWAA2012072606169Cap · missingFWD EEPLS END CAP MISSING AT ROW 1. INSTALLED END CAP PER M/M.SDR SWAA2012072606168Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE PER M/M.SDR SWAA2012071605819Cover · crackedEEPLS COVER CRACKED AT ROW 1. REMOVED AND REPLACED COVER IAW MM.SDR SWAA2012040902885Mount · brokenAFT GALLEY OVERHEAD EMERGENCY EXIT LIGHT MOUNTS BROKEN. REMOVED AND REPLACED LIGHT ASSY. PER MM.SDR SWAA2012040402821Skin · crackedLT HORIZONTAL STABILIZER LOWER INSPAR SKIN CRACKED A STA 129.50. REPAIRED SKIN PER SRM.
Back to N264LV