N934AN
Service difficulty reports · 246
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 = 'N934AN' 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 = 'N934AN' 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 AALA20140423009Light · inoperativeEMERGENCY LIGHT AT SEAT 27R INOPERATIVE. REPLACED LAMP FOR SEAT 27R EMERGENCY LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140423008Fuse · blownROW 27 HAS SEVERAL EMERGENCY LIGHTS INOPERATIVE. R & R FUSE IN EMERGENCY LIGHT BATTERY PACK M1672, OPERATIONS CHECKED NORMAL.SDR AALA20140113012Seat Track · crackedCRACKED SEAT TRACK FLANGE AT STATION 727B RBL 45.75. ACCOMPLISHED SPLICE REPAIR IAW ECOS J1701AA & J1707AB WITH EA B737-53-033125.SDR AALA20140113011Seat Track · crackedCRACKED SEAT TRACK FLANGE AT STATION 727B LBL 45.75. ACCOMPLISHED SPLICE REPAIR IAW ECOS J1701AA & J1707AB WITH EA B737-53-033125.SDR AALA20140113010Seat Track · crackedCRACKED SEAT TRACK FLANGE AT STATION 727B RBL 24.50. ACCOMPLISHED SPLICE REPAIR IAW ECOS J1701AA & J1707AB WITH EA B737-53-033125.SDR AALA20140108001Seat Track · crackedCRACKED SEAT TRACK FLANGE AT STATION 727B LBL 24.50. ACCOMPLISHED SPLICE REPAIR IAW ECOS J1701AA & J1707AB WITH EA B737-53-033125.SDR AALA20130920011Transmitter · faultyJFK INFLIGHT MIA-LGA, CREW REPORTED FLAP SPLIT LOCKOUT ON LANDING. EMERGENCY DECLARED FLIGHT DIVERTED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND RT FLAP POSITION TRANSMITTER FAULTED. REPLACED TE FLAP SENSOR R T428. SYSTEM GROUND CHESDR AALA20120924001Transmitter · inoperativeLAX - INFLIGHT DFW-SNA CREW REPORTED FLAP DISAGREE. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120321037Web · corrodedSTATION 1088 WEB, UNDER RIGHT VERTICAL STIFFENER, AT AUXILIARY POWER UNIT INLET CUTOUT IS CORRODED. INSTALLED DOUBLER PER EA B737-53-022380 AND BAC DWG 148A0924.SDR AALA20120321026Bulkhead · corrodedTHERE IS CORROSION ON THE STATION 1088 BULKHEAD JUST BELOW THE AUXLIARY POWER UNIT INLET DUCT, LOCATED IN THE JACKSCREW COMPARTMENT. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLER AND FILLERS PER SRM 51-70-11 AND EA B737-53-022380.SDR AALA20120321025Skin · corrodedTHE FUSELAGE SKIN UNDER THE DORSAL FIN HAS NUMEROUS AREAS OF CORROSION FROM STATIONS 887 TO 1016. REMOVED THE CORROSION PER SRM 51-10-02 AND EA B737-53-022550.SDR AALA20120321009Skin · gougedFUSELAGE SKIN HAS GOUGE IN WHITE STRIPE AREA, AFT OF LEFT AFT ENTRY DOOR, STATION 1005 BELOW LAP SPLICE. CUT OUT DAMAGE AND INSTALLED EXTERNAL REPAIR PER EA B737-53-022054.SDR AALA20120321006Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CAP, STATION 294.5. REPLACED UPPER CAP SECTION PER EA B737-53-022509, SRM 51-70-12 AND SRM 53-10-51.SDR AALA20120319005Intercostal · corrodedRIGHT AFT LAVATORY OUTBOARD INTERCOSTAL AFT END CORRODED. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA20120318001Skin · corrodedFUSELAGE SKIN CORRODED ABOVE RIGHT RAM AIR DEFLECTOR DOOR. INSTALLED DOUBLER REPAIR PER EA B737-53-022284.SDR AALA20120317006Filler · corrodedSTATION 1088 AUXILIARY POWER UNIT INLET CUTOUT LOWER FILLER IS CORRODED. REPLACED LOWER FILLER AT STATION 1088 AT AUXILIARY POWER UNIT INLET CUTOUT PER AARD 51-10-05.SDR AALA20120317005Angle · corrodedFOREWARD SIDE OF STATION 1088 AUXILIARY POWER UNIT INLET CUTOUT UPPER ANGLE IS CORRODED. REPLACED UPPER ANGLE ON AUXILIARY POWER UNIT INLET CUTOUT STATION 1088 PER AARD 51-10-05.SDR AALA20120317004Angle · corrodedSTATION 1088, AFT SIDE, AUXILIARY POWER UNIT INLET CUTOUT UPPER ANGLE IS CORRODED. REMOVED CORRODED SECTION AND INSTALLED FILLER AND DOUBLER PER SRM 51-70-11-R2.SDR AALA20120317003Stiffener · corrodedSTATION 1088 RIGHT VERTICAL STIFFENER AT AUXILIARY POWER UNIT INLET CUTOUT IS CORRODED AT LOWER END. REPLACED RIGHT VERTICAL STIFFENER ON AUXILIARY POWER UNIT INLET CUTOUT PER AARD 51-10-05 AND BOEING DRAWING 148A0924.SDR AALA20120317002Stiffener · corrodedSTATION 1088 AUXILIARY POWER UNIT INLET CUTOUT LEFT VERTICAL STIFFENER IS CORRODED. REPLACED LEFT VERTICAL STIFFENER AT STATION 1088 AUXILIARY POWER UNIT INLET CUTOUT PER AARD 51-10-05 AND BOEING DRAWING 148A0924.SDR AALA20120316009Angle · corrodedCORROSION ON RIGHT CREASE ANGLE AT STATIONS 294 TO 344. REPLACED ANGLE PER SRM 51-00-05-1 AND AARD 51-00-05-1.SDR AALA20120316008Strap · corrodedCORROSION ON TAPERED STRAP AT CREASE ANGLE FROM STATIONS 303 TO 312. REPLACED STRAP PER SRM 51-10-02-0G.SDR AALA20120316007Panel · crackedRIGHT NUMBER 1 DOOR CUTOUT PANEL HAS TWO CRACKED FASTENER HOLES. INSTALLED REPAIR ANGLE PER SRM 51-70-11-2R.SDR AALA20120316006Angle · corrodedCORROSION ON RIGHT CREASE ANGLE AT STATION 271. REPLACED ANGLE PER SRM 51-10-02-0G AND AARD 51-00-05-1.SDR AALA20120315005Floor Support · corrodedFLOORBOARD SUPPORT AT STATIONS 787 TO 847 RIGHT BUTTLINE 17. INSTALLED REPAIR STRAP PER EA B737-53-022430.SDR AALA20120315004Skin · damagedFUSELAGE SKIN DAMAGED AT STATION 494 STRINGER 22 RIGHT. REMOVED DAMAGE PER EA B737-53-022310.SDR AALA20120314015Skin · dentedA SMALL DENT WITH GOUGE IN THE FUSELAGE SKIN AT STATION 500I BETWEEN STRINGERS 20 AND 21 RIGHT. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLER PER SRM 53-00-01-2R REPAIR 6.SDR AALA20120314008Angle · corrodedT-ANGLE AT STATION 315, RIGHT BUTTLINE 11 CORRODED. REPLACED T-ANGLE PER AARD 51-00-05-1.SDR AALA20120314007Skin · damagedDENT WITH GOUGE IN FUSELAGE SKIN AT BODY STATION 903 STRINGER 2 TO 3 LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR AALA20120312013Angle · corrodedTHE CREASE ANGLE AT RIGHT AFT GALLEY DOOR IS CORRODED. REMOVED AND REPLACED THE RIGHT AFT CREASE ANGLE PER AARD 51-00-05-1.SDR AALA20120312012Angle · corrodedTHE LEFT CREASE ANGLE IS CORRODED FROM STATIONS 960 TO 988. REMOVED AND REPLACED THE LEFT AFT CREASE ANGLE PER AARD 51-00-05.SDR AALA20120312001Vapor Barrier · crackedRIGHT WHEEL WELL REAR SPAR VAPOR BARRIER HAS INTERIM REPAIR TO 22 INCH CRACK. INSTALLED REPAIR STRAPS AND ANGLES FOR BAYS 1R, 2R,4R PER SRM 57-10-10-2R, REPAIR 2.SDR AALA20120310003Floorbeam · corrodedFLOORBEAM AT STATION 328 HAS SPOT CORROSION IN AREA FROM RIGHT BUTTLINES 12 THRU 39. ACCOMPLISHED SPLICE REPAIR PER SRM 53-10-51-2R-7.SDR AALA20120309024Floorbeam · corrodedSTATION 986 FLOORBEAM CORRODED. REMOVED THE CORRODED T-CAP AND INSTALLED T-CAP REPAIR PER SRM 53-70-51-2R.SDR AALA20120309021Floor Support · damagedIN THE AFT CARGO THERE ARE TWO DRILL MARKS ON THE TOP SURFACE OF FLOOR SUPPORT STRINGER AT STATION 727A AT LEFT BUTTLINE 12.5. TRIMMED OUT THE DAMAGE AND INSTALLED REPAIR CHANNEL PER B737-800 SRM 53-00-53 REPAIR 2.SDR AALA20120309020Floor Support · damagedIN THE AFT CARGO 2 EACH HOLES DRILLED IN FLOOR SUPPORT STRINGER FORWARD OF STATION 727E AT LEFT BUTTLINE 12. TRIMMED OUT THE DAMAGE AND INSTALLED REPAIR CHANNEL PER B737-800 SRM 53-00-53 REPAIR 2.SDR AALA20120309019Floor Support · damagedIN THE AFT CARGO 2 EACH HOLES DRILLED IN FLOOR SUPPORT STRINGER FORWARD OF STATION 767 AT LEFT BUTTLINE 12. TRIMMED OUT THE DAMAGE AND INSTALLED REPAIR CHANNEL PER B737-800 SRM 53-00-53 REPAIR 2.SDR AALA20120309018Floor Support · damagedIN THE AFT CARGO 2 EACH HOLES DRILLED IN THE FLOOR SUPPORT STRINGER FORWARD OF STATION 727J AND LEFT BUTTLINE 12. TRIM OUT THE DAMAGE AND INSTALLED REPAIR CHANNEL PER B737-800 SRM 53-00-53 REPAIR 2.SDR AALA20120309017Cargo Track · damagedTWO DRILL MARKS ON THE SURFACE OF AFT CARGO TIE DOWN TRACK AT STATION 727C LEFT BUTTLINE 17.24. DRILLED OUT THE DRILL MARKS AND PLUGGED THE HOLES PER EA B737-53-022294.SDR AALA20120305013Vapor Barrier · crackedLEFT VAPOR BARRIER CRACKED BETWEEN BAYS 2 AND 4 LEFT. INSTALLED REPAIR STRAPS, ANGLES AND JOINT ANGLES FOR BAYS 2 AND 4 LEFT PER SRM - WINGLET SUPPLEMENT 57-10-10-2R 2.SDR AALA20120305011Stiffener · crackedLEFT VERTICAL STIFFENER CRACKED AT LOWER END JUST OUTBOARD OF PACK EXHAUST CUTOUT, AFT SIDE OF BULKHEAD. INSTALLED VERTICAL STIFFENER PER AARD 51-00-05-1 AND BOEING DRAWING NUMBERS 111A1000 AND 111A1308.SDR AALA20120304003Stiffener · corrodedSTIFFENER CORRODED ON AFT SIDE OF 1088 BULKHEAD, LEFT BUTTLINES 7 TO 9, 15 INCHES FROM BOTTOM. INSTALLED STIFFENER PER AARD 51-10-5 REPAIR 1 AND BOEING DRAWING 148A2410.SDR AALA20120303013Skin · dentedDENT WITH SCRATCHES BETWEEN STATIONS 500A TO 500C BETWEEN STRINGERS 21 TO 23 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R 3.SDR AALA20120302009Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500H AT STRINGER 26 LEFT INBOARD SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302008Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500H AT STRINGER 26 LEFT OUTBOARD SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302007Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500G AT STRINGER 26 LEFT FORWARD SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302006Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500G AT STRINGER 26 LEFT AFT SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302005Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500F AT STRINGER 26 LEFT AFT SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302004Fitting · crackedBAFFLE CLIP CRACKED AT STATION 500F AT STRINGER 26 LEFT FORWARD SIDE. REMOVED AND REPLACED BAFFLE CLIP PER AARD 51-10-05-1 AND EA B737-53-022092.SDR AALA20120302003Stiffener · crackedRIGHT VERTICAL STIFFENER OUTBOARD OF RIGHT PACK EXHAUST CUTOUT CRACKED AT LOWER END. REPLACED STIFFENER PER AARD 51-10-05-1 AND BOEING DRAWING 111A1000 AND 111A1308.
Back to N934AN