N18223
Service difficulty reports · 119
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 = 'N18223' 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 = 'N18223' 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 CALA2013052300333Frame · crackedFRAME CRACKED BS 440 BETWEEN S8-9L. CUT OUT DAMAGE AREA AND INSTALLED REPAIR ANGLE A AND B REF EA 5 310-04716, REV E.SDR CALA2013052300332Frame · crackedCABIN FRAME 400 CRACK AT SUPPORT FITTING BETWEEN STR 8 AND 9 RT. CUT OUT DAMAGE AREA AND INSTALLED REPAIR ANGLE A AND B, REF EA 5 310-04716, REV E.SDR CALA2013052100317Frame · crackedCABIN FRAME BS 380 CRACK AT SUPPORT FITTING BETWEEN S8-9 RT. INSTALLED REPAIR ANGLES A & B AT BS 380R, IAW EA 5310-04716 REV E, OP 2.SDR CALA2013052100316Frame · crackedFRAME CRACKED BS 480 BETWEEN S8-9L. ACCOMPLISHED FRAME REPAIR IAW EA 5310-04716, REV E.SDR CALA2013052100315Frame · crackedCABIN FRAME IS CRACKED AT BS 727D, RT BETWEEN STR 8 AND 9 RT INSTALLED REPAIR REF. STEPS 1-13 OF EA 5310-04716, REV E.SDR CALA2013052100320Angle · corrodedZEE ANGLE CORRODED BS 294 TO 360 CABIN FWD ENTRY. R & R ZEE ANGLE REF SRM 51-40-02.SDR CALA2013052100330Floor Support · crackedFLOOR SUPPORT CRACKED BS 328 TO 344 APPROX LBL 42. INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-02.SDR CALA2013052100329Floor Support · crackedFLOOR SUPPORT CRACKED BS 312 TO 328, RBL 42 CABIN FWD ENTRY INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-02.SDR CALA2011012600042Skin · dentedFUSELAGE HAS DENT JUST ABOVE STRINGER 10L AT BS 663.75 FUSELAGE SKIN. REPAIRED PER 53-00-01 REPAIR 3 OF SRM.SDR CALA2010072700347Oven · malfunctionedSTRONG SMELL OF ELECTRICAL SMOKE IN AFT GALLEY - OVENS POTS POWERED BUT NOT ON. SMELL DISSIPATED SHORTLY AFTER ALL WERE TURNED OFF. PULLED ALL GALLEY BREAKERS, CONTINUED SAN AFTER TALKING TO DISPATCH AND MX CONTROL EN ROUTE INSPECTED GALLEY AREA PER AMM 05-5SDR CALA2009071000367Cable · defectiveCABIN SEATS AISLE LIGHTING IS INOPERATIVE ON 3ABC AND 20ABC. CABIN SEATS AISLE LIGHTING 3ABC AND 20ABC CORRECTED PER AMM 33-51-11 AND SWP 20-61-00. OPS CHECK GOOD.SDR CALA0800844Bushing · corrodedNLG RT TRUNNION BUSHING HAS LIGHT PITTING CORROSION. REMOVED AND REPLACED RIGHTHAND INBOARD TRUNNION FITTING IAW BOEING DRAWING 141A7500 AND SRM 51-40-02.SDR CALA0600497Battery · dischargedTHE MID SECTION (RED LIGHTS BY OVERWING EXITS) OF EMERGENCY PATH LIGHTS WENT OUT AFTER 30 SECONDS OF ACTIVATION DURING TEST. THE BATTERY PACK FORWARD OF LEFT OVERWING EXIT FLOOR LEVEL (STA 559) WAS REPLACED.SDR CALA0500213Battery · dischargedTHE LEFT HAND AFT FLASHLIGHT LED WAS NOT BLINKING. THE FLASHLIGHT BATTERY WAS REMOVED AND REPLACED IAW MM 25-64-00.SDR CALA0300631Mount · corrodedINSPECTION FOUND AFT I/B G-2 GALLEY MOUNT CORRODED. THE CORROSION WAS REMOVED AND A DOUBLER WAS INSTALLED IAW ECRA 2531-01056.SDR CALA0300636Fitting · gougedTWO GOUGES WERE FOUND ON THE BRIDGE FITTING FOR THE LT INBOARD FLAP OUTBOARD CARRIAGE DURING A FLAP CHANGE. THE GOUGES WERE IN THE CENTER OF THE PART DIRECTLY BELOW THE BALLSCREW AND APPEARED TO BE CAUSED BY CONTACT WITH THE BALLSCREW. THE BRIDGE FITTING WASSDR CALA0200053Oven · inoperativeSMOKE WAS REPORTED COMING FROM THE FORWARD GALLEY NR 2 OVEN WHILE ENROUTE FROM CLE TO RSW. THE OVEN WAS SWITCHED OFF AND GALLEY POWER WAS DISCONNECTED. THE AIRCRAFT WAS DIVERTED TO CVG WHERE IT LANDED WITHOUT INCIDENT. THE FORWARD GALLEY NR 2 OVEN AND CONTROLLSDR CALA9901491Select. Valve · inopTHE RT MLG EXTENDED WHILE IN CRUISE AT FL 290 AND 300 KTS INDICATED AIRSPEED. BOTH RED AND GREEN GEAR LIGHTS FOR THE RIGHT GEAR WERE ILLUMINATED. THE ACFT WAS SLOWED TO 260 KTS AND ALL GEAR WERE FULLY EXTENDED, THEN RETRACTED. THE ACFT WAS RETURNED TO IAH WSDR CALA9901240Switch · failedTHE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF FROM PIT BOUND FOR EWR. ALL GEAR CIRCUIT BREAKERS WERE PULLED AND ATTEMPTS TO CYCLE GEAR HANDLE UP SEVERAL TIMES WERE UNSUCCESSFUL. THE GREEN AND THREE RED LIGHTS WERE DISPLAYED WITH THE HANDLE UP. THREE GREE
Back to N18223