N673AA, cancelled Apr 21, 2009
Service difficulty reports · 199
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 = 'N673AA' AND deregistration_id = 'N673AA-2009-04-21' 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 = 'N673AA' AND deregistration_id = 'N673AA-2009-04-21' 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 SWAA063783Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 752, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA063581Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA063580Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA063438Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA063437Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA063436Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA063435Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA062729Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 496, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA062581Casting · brokenFWD ENTRY DOOR UPPER GATE CENTER ROD END CASTING BROKEN. REMOVED AND REPLACED UPPER GATE CASTING PER MM.SDR SWAA062525Gasper Fan · faultyFAINT ELECTRICAL SMELL IN MID CABIN, TURNED OFF BOTH RECIRC AND GASPER FANS, PULLED C/B'S. SMELL DISSIPATED, PRIOR TO THIS OCCURRANCE THERE WAS LITTLE AIRFLOW THROUGH VENTS. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA062032Skin · crackedFUSELAGE SKIN CRACKED AT BS 845, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA061790Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 392, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA060132Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SWA EA.SDR SWAA060122Channel · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER SPLICE CHANNEL CRACKED BETWEEN BS 348 TO BS 360, STR 14L. REMOVED AND REPLACED SPLICE CHANNEL PER SRM.SDR SWAA060121Tab · crackedDURING SCHEDULED 1/4D CHECK, FOUND LT ELEVATOR TAB CRACKED AT NR 3 HINGE CUTOUT. REMOVED AND REPLACED TAB PER MM.SDR SWAA060120Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD WEB CRACKED AT DOME CAP, 12 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA060103Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 578, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA060102Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 727A, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053697Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA053300Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA053299Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRAKCED AT BS 480, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA053298Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRAKCED AT BS 315, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA052956Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 452, STR 16L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052293Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RIGHT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA050066Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 500D + 3, ABOVE STRINGER 12R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050065Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 290, STRINGER 15R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050064Pressure Panel · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EACH CRACKS AT NLG W/W FWD UPPER WEB AT BS 233, BS 234, BS 238, UPPER RIVET ROW. REPAIRED WEB PER SRM.SDR SWAA042860Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042656Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042251Lens · crackedFWD OVERHEAD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA042173Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 517, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041808Slide · out of adjustL2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041757Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 807, STRINGER 19L, BS 957, STRINGER 21L, CRACKED. REPAIRED SKIN PER SRM AND EA.SDR SWAA041743Door Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE CUTOUT LOWER RADIUS, CRACKED. REPAIRED FRAME HINGE CUTOUT PER EA.SDR SWAA041736Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040994Lens · brokenDURING SCHEDULED SERVICE CHECK, FOUND FWD EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LENS PER MM.SDR SWAA040836Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN AT BS 767, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040691Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA040398Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT NLG WHEEL WELL BS 245.5, BELOW LT PRESSURE PANEL. REPAIRED SKIN PER EA.SDR SWAA040196Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACK AT BS 807. REPAIRED SKIN PER SRM.SDR SWAA032307Retainer · brokenFWD EMERGENCY FLASHLIGHT BASE ASSY BROKEN. REMOVED AND REPLACED BASE ASSY PER MM.SDR SWAA031759Keelbeam · corrodedDURING SCHEDULED D CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500C, WL146 AND LBL 6. REPAIRED KEEL BEAM PER SRM.SDR SWAA031758Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CRACKED AT BS 947.5, WL 208 AND LBL 53. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA031757Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME PER SRM.SDR SWAA031756Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) BETWEEN STR 8L AND STR 9L, BS'S 827, 867, 887 AND 907. REPAIRED FRAMES PER SRM.SDR SWAA031744Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, BETWEEN STR 22R AND STR 23R. REPAIRED FRAME PER SRM.SDR SWAA031691Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 767, WL 148 AND RBL 8. REPAIRED SHEAR TIE PER SRM.SDR SWAA031679Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKRD (2 EA) AT BS 500, WL 148 AT RBL 8 AND BS 827, WL 148 AT RBL 3. REPAIRED FRAMES PER SRM.SDR SWAA031665Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER CORRODED AT BS 1003, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA031651Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, WL 148 AND LBL 3. REPAIRED SHEAR TIE PER SRM.
Back to N673AA, cancelled Apr 21, 2009