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 SWAA20111205397Cover · crackedDURING SCHEDULED CV CHECK, FOUND LT EEPLS COVER CRACKED AT ROW 11. REMOVED AND REPLACED COVER PER MM.SDR SWAA117642Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND FWD EEPLS INOP AT ROW 1. RELAMPED EEPLS PER MM.SDR SWAA117211Window · crackedL1 WINDOW CRACKED AND ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA116471Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER ASSY PER MM.SDR SWAA114263Light · brokenDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA114175Lens · brokenFWD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN.SDR SWAA112864Lens · brokenDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA111829Cover · missingEMERGENCY EXIT FLOOR LIGHTING COVER MISSING. REPLACED COVER PER MM.SDR SWAA107908Battery · failedDURING SCHEDULED HC2 CHECK, RT EMERGENCY EXIT LIGHT FAILED CAPACITY TEST. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA107907Battery · failedDURING SCHEDULED HC2 CHECK, LT EMERGENCY EXIT LIGHT FAILED CAPACITY TEST. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA107910Charger · inoperativeDURING SCHEDULED HC2 CHECK, FOUND RT FWD EMERGENCY EXIT LIGHT BATTERY CHARGER INOP. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA107909Lens · brokenDURING SCHEDULED HC2 CHECK, FOUND EEPLS LENS BROKEN AT ROW 22. REMOVED AND REPLACED LENS PER MM.SDR SWAA107109Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 129.5. REPAIRED SKIN PER SRM.SDR SWAA104659Cover · looseFWD EEPLS COVER LOOSE. SECURED COVER PER MM.SDR SWAA104205Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA103535Lens · brokenDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA102444Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND EEPLS INOP AT ROW 1. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096487Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA092704Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED EMERGENCY LIGHT PER MM.SDR SWAA092076Cover · brokenFWD GALLEY EEPLS COVER BROKEN. REMOVED AND REPLACED END CAP PER MM.SDR SWAA092011Lens · looseFWD EEPLS LENS LOOSE. SECURED LENS PER MM.SDR SWAA085175Cover · missingL1 DOOR EXIT LIGHT COVER MISSING. REPLACED COVER PER SWA EA.SDR SWAA074717Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073770Skin · damagedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CREASED AT BS 963, STR 21L. REPAIRED SKIN PER SWA EA.
Back to N264LV