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 MASA2011052602854Cover · missingEMERGENCY LIGHT COVER AT GALLEY DOOR MISSING. INSTALLED REPLACEMENT COVER.SDR MASA2011051902781Light · inoperativeFLOOR LEVEL EXIT SIGN AT ROW 16F 1 BULB. R2 BULB.SDR MASA2011051602728Engine · vibrationENG 1 N1 VIBE AT 2.0 IN CRUISE. SHOOK BLADES, ENG RUN AT .4MILS.SDR MASA2011050602630Sensor · malfunctionedINTERMIT BRAKE OVERHEAT WARNING NR 3. R&R NR 3 BRAKE TEMP SENSOR.SDR MASA2011050302599Light · inoperativeNR 8 CEILING EMER FLOOD LIGHT OUT. R2 BULB.SDR MASA2011050302595Light · inoperativeNR 5 CEILING FLOOD LIGHT OUT. R2 BULB.SDR MASA2011022402012Pitot Tube · dentedNR 1 PITOT TUBE INLET DENTED. MX REMOVED AND REPLACED NR 1 PITOT TUBE ASSY.SDR MASA2011021801964Light · inoperativeROW 4 CEILING LEVEL [EMERGENCY] FLOOD LIGHT INOP. MX RELAMPED.SDR MASA2011021801963Light · inoperativeROW 20 CEILING LEVEL [EMERGENCY] FLOOD LIGHT INOP. MX RELAMPED.SDR MASA2011020101850Release Pin · brokenPAX DOOR HANDRAIL PIN LANYARD BROKEN. MX REMOVED AND REPLACED PAX DOOR HANDRAIL PIN/LANYARD ASSY.SDR MASA2011012401776Flap · dentedRIGHT I/B FLAP DENT. MAINTENANCE R2 I/B FLAP C/W ELECTRICAL & MECHANICAL RIG OPS CHECKED.SDR MASA2011011901724Light · inoperativeCABIN CEILING EMERGENCY LIGHT ROW 7 INOP. MX RELAMPED EMERGENCY LIGHT.SDR MASA2011011901723Light · inoperativeCABIN CEILING EMERGENCY LIGHT ROW 23 INOP. MX RELAMPED EMERGENCY LIGHT.SDR MASA2011010401602Sensor · faultyNR 3 BTMS BRAKE OVERHEAT WARNING IN FLIGHT. MX REPLACED SENSOR.SDR MASA2010122301538Warning System · malfunctionedPROX SYS FAULT 2 STATUS MSG-PAX DOOR. MX CYCLED PAX DOOR, FAULT CLEARED, NFAR.SDR MASA2010120701396Spring · brokenMAIN ENTRY DOOR FWD HAND RAIL BUMPER SPRING BROKEN. MX REPLACED WITH NEW BUMPER SPRING AND HARDWARE.SDR MASA2010111701295Placard · missing"TO OPEN" PLACARD MISSING FROM MED STAIRS. MX INSTALLED NEW "TO OPEN" PLACARD ON MAIN ENTRY DOOR STAIRS.SDR MASA2010110801237Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT INOP. MX RELAMPED.SDR MASA2010101101113Bleed Valve · leakingRIGHT ENGINE FLUID LEAK. MX REPLACED THE OBV.SDR MASA2010092101013Motor · malfunctionedPAX DOOR ASSIST CABLE BROKEN. MX R2 PAX DOOR ASSIST MOTOR & FWD GAS STRUT OPS CHECK GOOD.SDR MASA2010091500986Light · inoperative2 NON SEQUENTIAL O/H FLOOD LIGHTS INOP. MX RELAMPED.SDR MASA2010090800969Placard · missingMAIN PAX DOOR EXIT MISSING PLACARD. MX R2 PLACARD.SDR MASA2010081100871Battery · dischargedFWD ATT FLASHLIGHT INDICATOR INOP. MX R2 BATTERY.SDR MASA2010071100748Seal · dirtyPAX DOOR SQUEALING. INSPECTED AND CLEANED LUBE SEAL.SDR MASA2010062900706Battery · inoperativeCAPTAIN'S FLASHLIGHT INOP. REPLACED BATTERY.SDR MASA2010061900663Flashlight · inoperativeF/O'S FLASHLIGHT INOP. MX REPLACED F/O'S FLASHLIGHT AMM 25-61-00.SDR MASA2010061000625Light · inoperativeROW 20 OVERHEAD EMERGENCY FLOOD INOP. MX RELAMPED.SDR MASA2010051700515Escape Hatch · lack of lubeESCAPE HATCH WHISTLING AT ALTITUDE. LUBED HATCHSDR MASA2010041900365Lens · wrong partOVERHEAD EXIT ROW LIGHT WRONG COLOR FWD. REPLACED RED LENS.SDR MASA2010041000330Battery · dischargedEMERGENCY LIGHTS INOP. CHARGED EMERGENCY BATTERIES, LIGHTS OP GOOD.SDR MASA2010031100201Light · inoperativeROW 17 EMERGENCY FLOOD LIGHT OUT. MX REPLACED ROW 17 EMERGENCY FLOOD LIGHT BULB IAW AMM.SDR MASA2010022300159Light · inoperativeROW 15 FLOOR LEVEL EXIT SIGN HAS 1 BULB OUT. RELAMPED EXIT SIGN.SDR MASA2010012800095Light · inoperativeROW 7 EMERGENCY FLOOD LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR MASA2010010700029Light · inoperativeTHIRD AISLE EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR MASA2009123000128Tire · separatedRIGHT NLG TIRE TREAD SEPARATED. REMOVED AND REPLACED BOTH NLG WHEELS.SDR MASA2009042000132Power Supply · looseASH FLT 2838 PHX - BUR - AFT 3 EMERGENCY LIGHTS IN THE AFT ON THE CEILING INOP. MAINTENANCE SECURED POWER SUPPLY UNIT.SDR MAS2008F00098Lamp · inoperativeFLT 2719 - AFT CEILING LIGHT INOPERATIVE. MX RELAMPED.SDR MAS2008F00081Lamp · inoperativeCREW REPORTED EMERGENCY EXIT LIGHT AT 16A AND AN EMERGENCY EXIT LIGHT AT ROW 7 INOPERATIVE. MX RELAMPED. (K)SDR MAS2008F00028Battery Pack · inoperativeASH FLT 2679 CLT-SAT. EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES. (S)SDR MASA200800462Connector · dirtyASH FLT 2934 FAT-PHX. SERVICE DOOR EXIT LIGHT INOP. MX CLEANED CONNECTORS--LIGHT OPS GOOD. (B)SDR MASA200800404Structure · crackedFOUND RT MLG DOOR CROSS MEMBER CRACKED AND SEVERAL LOOSE RIVETS ON INNER SKIN LEADING EDGE NEXT TO FWD HINGE. REPLACED MLG DOOR.SDR MASA200800293Light · inoperativeASH FLT 2653 CLT-PNS. ROW 17 CEILING EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR MASA200700881Warning Message · illuminatedASH FLT 2665 - INBOUND TO CLT, PITCH FEEL CAUTION MESSAGE. MX PERFORMED AN S-POST TEST, FAULTS CLEARED. NO DEFECTS NOTED.SDR MASA200700496A/C Pack · smokeASH 2615 CLT - CAPTAIN REPORTED SMOKE IN THE CABIN. MX PLACED THE RT PACK ON MEL.SDR MASA200700120Strip · looseASH 2602 CLT. EMERGENCY FLOOR STRIP ROW 16 NOT SECURE. MX SECURED STRIP.SDR MASA200700117Garlock Seal · leakingASH 9390 BWI - THE A/C DIVERTED TO IAD DUE TO THE NR 1 ENGINE OIL LOW. ENGINE SHUT DOWN DURING FLIGHT. MX REMOVED AND REPLACED EDP GARLOCK SEAL O-RING.SDR MASA20062737Unknown · unknownASH 2664 CLT - SPOILER/STAB FAULT. PERFORMED SPOST W/FLIGHT CREW. NO FURTHER DEFECTS NOTED.SDR MASA200800040Skin · corrodedCORROSION DAMAGE (3 OFF AREAS), 0.026 INCH MAX DEPTH TO RT WING LOWER PLANK FUEL TANK ACCESS PANEL AT LOWER PANEL LOCATION 541AB. THE DAMAGE MEASURE 1/10" WIDE IN FWD AND AFT DAMAGED AREAS. REPAIRED DAMAGE.SDR MASA200602481Computer · faultyASH 2662 CLT. PITCH FEEL FAULT/SSCU 2 FAULT STATUS. MX REMOVED AND REPLACED STALL PROTECTION COMPUTER. NO FURTHER DEFECTS NOTED.SDR MASA200602477Pcu · malfunctionedASH 2833 OAK. CAPTAIN REPORTED A I/B SPOILERON AND I/B FLT SPOILER CAUTION MESSAGE IN FLIGHT. MX REMOVED AND REPLACED RIGHT INBOARD MFSPCU.
Back to N921FJ