N921FJ
Service difficulty reports · 330
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 = 'N921FJ' 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 = 'N921FJ' 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 MASA2015090212357Bulb · burned out14DF EMERGENCY EXIT LIGHT 1 BULB BURNED OUT. PLACED ON MEL.SDR MASA2015072712273Sign · detachedEMERGENCY FLOOR FLOOD LIGHT 14C PANEL DETATCHED. SECURED THE EMERGENCY LIGHT PANEL.SDR MASA2015042312021Light · inoperativeROW 9 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2015041512044Shutoff Valve · leakingRETURN TO FIELD, EMERGENCY DECLARED. LT BLEED DUCT WARNING. ISOLATED LEAK BY PLACING PRSOV BLEED ON MEL.SDR MASA2015033012990Light · inoperativeCEILING EMERGENCY FLOOD LIGHT, ROW 6 INOPERATIVE, PLACED ON MEL.SDR MASA2015032612976Cradle · inoperativeAFT F/A FLASHLIGHT CONSIDERED INOPERATIVE DUE TO HOLDER INOPERATIVE, PLACED ON MEL.SDR MASA2015030512943Battery Pack · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED BATTERY.SDR MASA2015022212915Light · inoperativeROW 15 EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2015020812889Bulb · inoperative14DF FLOOR LEVEL EMERGENCY LIGHT HAS ONE BULB INOPERATIVE.SDR MASA2015020812888Bulb · inoperative13DF FLOOR LEVEL EMERGENCY LIGHT HAS ONE BULB INOPERATIVE.SDR MASA2015011712859Light · inoperativeAFT CABIN EMERGENCY CEILING LIGHT INOPERATIVE.SDR MASA2014102202683Bulb · inoperativeONE BULB FOR FLOOR EMERGENCY EXIT SIGN INOPERATIVE.SDR WVER2014092003Bulkhead Web · corrodedFS 280 BULKHEAD WEBS HAVE WIDESPREAD CORROSION.SDR WVER201409200002Floor Support · corrodedRIGHT FLOOR SUPPORT FROM BS 280-319 HAS SEVERAL AREAS OF CORROSION.SDR WVER2014092092101Floorbeam · corrodedBS 280, FLOORBEAM HAS WIDESPREAD CORROSION.SDR WVER201409160001Skin · chafedTHREE CHAFES FOUND ON LOWER EXTERNAL SKIN ALONG STRINGER 27. AT BS 913 AND BETWEEN BS 913 AND 927.SDR WVER2014091690501Skin · chafedTHREE CHAFES FOUND ON LOWER SKIN ALONG STRINGER 27 AT BS 913 AND BETWEEN BS 913 AND BS 927.SDR MASA2014071402238Bulb · unsecureLIGHT OUT AT SIDEWALL EXIT TIP ROW 13A-C. MAINTENANCE SECURED BULB.SDR MASA2014071102223Bulb · inoperativeFOUND RT LOWER EMERGENCY LIGHT WITH ONE PEANUT BULB OUT. R & R PEANUT BULB, OPS CHECKED GOOD.SDR MASA2014071102222Bulb · inoperativeFOUND FWD ENTRY LOWER EMERGENCY WITH ONE PEANUT BULB OUT. R & R PEANUT BULB, OPS CHECKED GOOD.SDR MASA2014042731061Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE.SDR MASA2014040831006Lamp · inoperativeROW 13A OVERWING EXIT SIGN HAS ONE LAMP INOPERATIVE.SDR MASA2014021130929Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY PACKS.SDR MASA2014012420892Power Supply · dischargedOVERHEAD EMERGENCY LIGHTS DIM. CHARGED EPSU WITH AIRCRAFT POWER.SDR MASA2014012220887Battery Pack · dischargedROW 1 TO ROW 11, CEILING 5 EMERGENCY LIGHTS INOPERATIVE. ALLOWED ACFT ELECTRICAL POWER TO RECHARGE EPSU, OPS NORMAL.SDR MASA2013092267843Bulb · inoperativeROW 20, EMERGENCY FLOOD LIGHT BURNED OUT. MX REPLACED BULB.SDR WVER20130816001Strap · damagedRT WING STRAP, FOUND 18 DISCREPANT HOLES IN COLD WORKED AND NON COLDWORKED HOLES.SDR MASA2013070952328Brake · inoperativeOTBD BRAKES INOPERATIVE. REPLACED NR 3 & 4 BRAKES.SDR MASA2013060154261Battery Pack · dischargedAFT F/A MICROPHONE INOPERATIVE. MX REPLACED THE MEGAPHONE BATTERY PACK.SDR MASA2013041052477Pin · defectiveRIGHT OVERWING EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED GROUND WIRE PIN.SDR MASA2013030952431Battery Pack · misinstalledROW 13 LT AND RT EMERGENCY SIGNS INOP. CORRECTLY INSTALLED NR 5 BATTERY PACK.SDR MASA2012111852295Switch · defectiveMAIN CABIN DOOR WILL NOT OPEN (DUE PAX DOOR MOTOR RETRACTING DOOR). R2 SWITCH OPS NORMALSDR MASA2012111252283Battery Pack · dischargedCOCKPIT FLASHLIGHT INOP. REPLACED BATTERY PACK.SDR MASA2012110352264Light · inoperativeFLOOR LEVEL EMERGENCY EXIT SIGN AT ROW 14 INOPERATIVE UPON POST FLIGHT INSPECTION. MAINTENANCE REPLACED THE LAMPS.SDR MASA2012101252227Battery · inoperativeAFT FLIGHT ATTENDANT'S FLASHLIGHT INOPERATIVE ON POST FLIGHT INSPECTION. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY PACK.SDR MASA2012082925076Warning System · false activationRTF LEFT BLEED DUCT WARNING. RESET AILC RAN ENGINES OPERATED BLEEDS, OPS CHECKED.SDR MASA2012082635068Connector · looseABORTED TAKEOFF FOR ANTI INBOARD SKID CAUTION MESSAGE / INDICATION ON EICAS. MAINTENANCE FOUND AND SECURED A LOOSE CONNECTION AT THE LEFT INBOARD WHEEL SPEED TRANSDUCER.SDR MASA2012072635000Duct · unknownAIR RETURN, EMERGENCY DECLARED, LEFT BLEED AIR DUCT WARNING. BLEEDS SHUTDOWN. MAINTENANCE REMOVED AND REPLACED 10TH STAGE CROSSOVER DUCT AND LEFT PACK BELLOWS.SDR MASA2012060334849Door · bindingRIGHT FORWARD SERVICE DOOR HARD TO OPEN AND CLOSE. CLEANED AND LUBED DOOR.SDR MASA2012052734821Bulb · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN HAD 1 BULB INOPERATIVE ON POST FLIGHT INSPECTION. THE BULB WAS PLACED ON MEL.SDR MASA2012050234747Battery · inoperativeFLIGHT 2641, REPORTED AN INOPERATIVE FLASHLIGHT ON PRE FLIGHT INSPECTION. REMOVED AND REPLACED BATTERY.SDR MASA2012040934682Lamp · inoperativeFLIGHT 2664, REPORTED THREE EMERGENCY EXIT SIGN LAMPS AT THE SERVICE DOOR & EMERGENCY EXIT INOPERATIVE ON POST FLIGHT INSPECTION. MAINTENANCE REPLACED THE LAMPS IN THE SIGN ASSEMBLY.SDR MASA2012040934681Lamp · inoperativeFLIGHT 2664, REPORTED ROW 19 EMERGENCY CEILING FLOOD LIGHT INOPERATIVE. MAINTENANCE REPLACED THE LAMP IN THE LIGHT ASSEMBLY.SDR MASA2012032034592Battery · dischargedF/O FLASHLIGHT INOPERATIVE DUE TO INCORRECT INSTALLATION. R2 BATTERY.SDR MASA2012030534528Flashlight · inoperativeF/O FLASHLIGHT INOP. R2 F/O FLASHLIGHT, OPS CHECK GOOD.SDR MASA2012030134506Spar · gougedRT WING AT WS 158.00 HAS GOUGE FROM TOOLING ON FWD FACE MEASURES .085"L X .085"W X .035" DEEP. REPAIRED AREA IN ACCORDANCE WITH BOMBARDIER REO 690-57-21-038.SDR MASA2012022834494Fitting · wornFS 280.00 THE HORIZONTAL STABILIZER PIVOT FITTING ANIT ROTATION TABS ARE WORN. BLENDED THE ANTI ROTATION TABS SMOOTH IAW RO CRJ9-55-0153, CRJP-55-0153 AND REO 690-55-11-038.SDR MASA2012022434480Doubler · defectiveFS 797 REINFORCING DOUBLER P/N KSH670-35824-21 FASTENER HOLE HAS NO EDGE DISTANCE DUE TO SHORT DIMENSION OF PART ISSUED. REPAIRED DOUBLER IAW BOMBARDIER REO CL600-25-L00969.SDR MASA2012022334475Support · corrodedFS 1098.20 AFT SIDE OF PRESSURE BULKHEAD SUPPORT STRUCTURE JUST LEFT OF THE FLOATATION VALVE IS CHAFED APPROX 0.050" DEEP FROM FLOATATION VALVE HINGE PIN. REPAIRED SUPPORT STRUCTURE AND FLOATATION VALVE HINGE PIN IAW BOMBARDIER REO 690-53-61-245 AND BOMBARDIESDR MASA2012022934502Skin · dentedHORIZONTAL STABILIZER SKIN AND RT ELEVATOR LOWER SKIN DAMAGED AT HINGE 3 OF RT ELEVATOR BY TOOLING. REPAIRED ELEVATOR LOWER FORWARD SKIN AND HORIZONTAL STAB LOWER TRAILING SKIN IN ACCORDANCE WITH ENGINEERING ORDER CL600-2D24-55-L00997.
Back to N921FJ