N85323
Service difficulty reports · 107
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 = 'N85323' 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 = 'N85323' 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 JR2R20230412153Beam · corrodedFLOOR BEAM AT RBL11 CORRODED BETWEEN FR86 THRU FR87SDR JR2R20230412151Strap · corrodedFLOOR BEAM AT RBL11 CORRODED BETWEEN FR85 THRU FR86SDR JR2R202304125155Shear Panel · corrodedFLOOR WEB ON TOP OF FR87 CORRODED BETWEEN RBL12 THRU RBL40SDR JR2R20230412193Channel · corrodedAFT RH MOP SILL FR88-FR90 CORRODEDSDR JR2R20230412209Support · corrodedGALLEY SUPPORT BETWEEN FR87 AND FR88 AT RBL24 CORRODEDSDR JR2R20230412210Support · corrodedPANEL SUPPORT ON THE FWD SIDE OF FR87 AT RBL24 CORRODEDSDR JR2R20230408199Angle · crackedANGLE CLIP ON THE FWD SIDE OF FLOOR BEAM 12 UNDER LH SIDE COUNSIL IS CRACKEDSDR JR2R20230408156Angle · crackedWING SPAR 2 LOWER ANGLE LOCATED FWD OF LH WHEEL WELL FWD SIDE OF BULKHEAD CRACKEDSDR 2021FA0000329None · noneCA FLASHLIGHT NOT CHARGING- PLACED ON MELSDR MASA2021090600227Power Supply · inoperativeFD OVERHEAD EMER LIGHT INOP. REPLACED EMERGENCY LIGHT POWER SUPPLY.SDR JR2R20210415188Spar · crackedRH WINGTIP #1 SPAR IS CRACKED AND REQUIRES REPLACEMENTSDR JR2R20210415187Spar · crackedLH WINGTIP #1 SPAR CRACKED AND REQUIRES REPLACEMENTSDR JR2R20210404109Beam · corrodedFLOOR CROSSBEAM AT FR17 AT RBL12 HAS AREA OF CORROSIONSDR JR2R20210404111Beam · corrodedFLOOR CROSSBEAM AT FR17 AT LBL11 HAS AREAS OF CORROSIONSDR JR2R202104034114Shear Web · corrodedFLOOR SUPPORT WEB FR87-88 RBL 11 TO RBL41 CORRODED OUT OF LIMITS. REMOVED AND REPLACED PART.SDR JR2R202104034108Floorbeam · corrodedFLOOR BEAM FR 12-14 RBL 11 CORRODED OUT OF LIMITS. REPAIRED FLOOR BEAM IAW EMB 175 SRM 53-10-10 REPAIR 01.SDR JR2R202104034113Shear Web · corrodedFLOOR SUPPORT WEB FR87-88 RBL 11-LBL11 CORRODED OUT OF LIMITS. REMOVED AND REPLACED PART.SDR JR2R202104034116Splice Plate · corrodedFLOOR SUPPORT SPLICE PLATE AT FR90 RBL 25 CORRODED OUT OF LIMITS. REMOVED AND REPLACED PART.SDR JR2R202104034112Floor Support · corrodedR/H O/B FLOOR SUPPORT FR88-FR90 CORRODED OUT OF LIMITS. REMOVED AND REPLACED PART.SDR JR2R20210403Support Web · corrodedR/H FLOOR BEAM SUPPORT WEB BETWEEN FR12-FR14 CORRODED OUT OF LIMITS. REMOVED AND REPLACED WEB.SDR JR2R202104034159Seat Track · corrodedL/H SEAT TRACK AT FR 17 RBL 12 FWD LUG CORRODED OUT OF LIMITS. REPAIRED SEAT TRACK IAW EMB 175 SRM 53-00-10.SDR JR2R202104034118Floorbeam · corrodedFLOOR BEAM AT FR85 RBL 11 CORRODED OUT OF LIMITS. REPAIRED FLOOR BEAM IAW EMBRAER ETD 2021-170-008756.SDR JR2R202104034117Floorbeam · corrodedFLOOR BEAM AT FR 87 LBL 11 IS CORRODED AT AND AROUND RIVET. FOUND TO BE OUT OF LIMITS. REPAIRED BEAM IAW EMB 175 SRM 53-23-10.SDR JR2R202104033859Frame · crackedL/H WHEEL WELL FWD FRAME 52 IS CRACKED. REPAIRED CRACK IAW EMB 175 SRM 53-22-04 FIG 22.SDR JR2R202104024050Rib · crackedR/H H-STAB HAS CRACKED RIB AS SEEN FROM 3RD INSPECTION HOLE FROM O/B END OF FWD SPAR. REPAIR WAS ACCOMPLISHED BY PERFORMING EMBRAER SERVICE BULLETIN 170-55-0014.SDR MASA2020080810146Flashlight · inoperativeFORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. OPENSDR MASA2020041210155Flashlight · inoperativeCA'S FLASHLIGHT INOP
PLACED ON MELSDR MASA2019121712186Battery · inoperativeFWD FA FLASHLIGHT NOT CHARGING. REPLACED FLASHLIGHT BATTERIES, OPS NORMAL.SDR MASA2019071011944Battery · dischargedFWD F/A FLASHLIGHT INOP. R&R BATTERY.SDR MASA2019070811941Battery · dischargedAFT F/A FLASHLIGHT INOP. REPLACED BATTERY.SDR MASA2019051211853Battery · dischargedFWD FA FLASHLIGHT INOP. REPLACED FLASHLIGHT BATTERY.SDR JR2R20190502335Skin · dentedRT AFT FUSELAGE SKIN - THROUGH DAMAGE HOLE; TWO DENTS. PERFORMED PERMANENT REPAIR IAW ETD 2019-170-059335.SDR JR2R20190402775Skin · dentedRT AFT FUSELAGE SKIN - THROUGH DAMAGE HOLE; TWO DENTS. REPAIRED FUSELAGE SKIN IAW ETD2019-170-056775.SDR MASA2019010311632Battery · dischargedFWD FA FLASHLIGHT INOP. MX REPLACED THE BATTERY.SDR MASA2018092211396Flashlight · inoperativeFWD FA FLASHLIGHT INOP. PLACED ON MEL.SDR MASA2018082313509Light · inoperativePHOTOLUMIN STRIP AT FWD FA CLOSET INOP.SDR MASA2018051603205Flashlight · inoperativeFWD FA FLASHLIGHT INOPERATIVE.SDR MASA2018051603182Flashlight · inoperativeAFT FA FLASHLIGHT INOPERATIVE.SDR MASA2018041113129Flashlight · inoperativeFWD FA FLASHLIGHT INOP. PLACED ON MEL.SDR MASA2018020612955Battery Pack · inoperativeFIRST OFFICER`S FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR MASA2017112112781Sign · inoperativeFWD SERVICE DOOR EXIT SIGN INOPERATIVE.SDR MASA2017081312536Flashlight · inoperativeFWD F/A FLASHLIGHT INOP. PLACED ON MEL.SDR MASA2017051412299Flashlight · inoperativeFWD FA FLASHLIGHT INOP. PLACED ON MEL.SDR MASA2017031612669Battery · dischargedAFT FA FLASHLIGHT INOP. REPLACED BATTERY.SDR MASA2017202612629Flashlight · inoperativeFWD FA FLASHLIGHT INOPERATIVE.SDR MASA2016112212490Flashlight · inoperativeFWD F/A FLASHLIGHT NOT BLINKING.SDR MASA2016090312354Battery · dischargedF/O EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR MASA2016062812809Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. PLACED ON MEL.SDR MASA2016031812834Bottle · low pressureR2 DOOR PNEUMATIC PRESSURE ASSY FOUND 850 PSI BELOW SERVICEABLE LIMITS IAW MM 52-00-00.SDR MASA2016031812833Bottle · low pressureR1 DOOR PNEUMATIC PRESSURE ASSY FOUND 850 PSI BELOW SERVICEABLE LIMITS IAW MM 52-00-00 MO55, CREATED FOR GVI AFTER 24 HRS. 2X NRS CREATED FOR SERVICING AND GVI FROM 24 HRS AFTER SERVICING, SUBMITTING SUPPLEMENTAL INFORMATION FOR CLOSING C/A FOR PREVIOUSLY SUB
Back to N85323