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 MASA2020012100031Light · inoperativeROW 1 CEILING LEVEL EMERG FLOOD LIGHT INOP- PLACED ON MELSDR MASA2019082512019Light · inoperativeENTRY EMER LIGHT FLOOR LVL INOP. REPLACED LIGHT ASSY.SDR MASA2019052111868Light · inoperativeROW 14DF FLOOR EMER LIGHT 1 BULB INOP. PLACED ON MEL.SDR MASA2019052111867Light · inoperativeROW 14AC FLOOR EMER LT 2 BULBS INOP. PLACED ON MEL.SDR MASA2018042211820Sign · inoperativeROW 14 D/F EMER EXIT SIGN 1 LT INOP. OPS CHECKED GOOD.SDR MASA2018092711414Bulb · inoperativeROW 14DF EXIT SIGN HAS ONE BULB INOP. PLACED ON MELSDR MASA2018092511410Light · inoperativeEMERG OVERHEAD FLOOD LIGHT ROW 18 INOP. PLACED ON MELSDR MASA2018060543291Flashlight · inoperativeFWD FA FLASHLIGHT INOPERATIVE.SDR MASA2018041613142Lamp · inoperativeROW 9, OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2018030513030Flashlight · inoperativeAFT FA FLASHLIGHT RED LIGHT NOT BLINKING. PLACED ON MEL.SDR MASA2018012112928Light · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE.SDR MASA2017121312828Battery Pack · inoperativeFWD LEFT & RIGHT EXT EMERG OVERWING LIGHTS INOP. REPLACED BATTERY AND CHARGERSDR MASA2017110112736Battery · dischargedFWD FA FLASHLIGHT INOP. REPLACED BATTERY.SDR MASA2017091912645Light · inoperativeROW 21 CEILING EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017051712308Battery Pack · inoperativeSEVERAL EMERGENCY FLOOD LIGHTS INOPERATIVE. REPLACED THE NR 2 BATTERY PACK.SDR MASA2017012312825Light · inoperativeSECOND TO AFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR WVER2016121092109Intercostal · corrodedINTERCOSTAL AT STR 20R IS CORRODED BETWEEN FS 310- FS 319.SDR WVER2016121092108Hinge · gougedPASSENGER DOOR HINGE (FUSELAGE SIDE) GOUGED ON MOST AFT LANDING AND FACE APPROX .75" LONG, .060" WIDE, .100" DEEP.SDR WVER2016120492106Angle · corrodedSERVICE DOOR SILL ANGLE IS CORRODED IN MULTIPLE LOCATIONS BETWEEN FS 319.70 TO FS 349.0.SDR WVER2016120192104Door Sill · corrodedAFT BAGGAGE BAY DOOR CUT OUT, FLOOR SILL CORRODED, P/N:MM670-35655-001. REMOVED AND REPLACED WITH SERVICEABLE P/N MM670-35655-001 FLOOR SILL IAW SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01 & 51-42-21-001-001-A01.SDR WVER2016113092103Drag Angle · crackedLT VERTICAL STABILIZER FORWARD DRAG ANGLE IS CRACKED.SDR WVER2016112892101Frame · chafedRT SIDE AT FS 1144 FRAME IS CHAFED BY WATER INJECTION LINE AT STRINGER 9.SDR WVER2016112692102Seat Track · corrodedRT CABIN FLOOR TRACK SEGMENT BL9.0 FS 349-FS 421.0 IS CORRODED.SDR WVER2016112292101Stringer · chafedBS 1144 AND 1162 STRINGER 7L IS CHAFED AND SUPPORT BRACKET IS BROKEN.SDR MASA2016090912370Sign · inoperativeLIGHTED EXIT SIGN AT ROW 3 WAS FOUND INOPERATIVE.SDR MASA2016090712362Bulb · inoperativeROW 3 EXIT SIGN HAD TWO BULBS INOPERATIVE.SDR MASA2016090512360Flashlight · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. PLACED ON MEL.SDR MASA2016083112350Battery Pack · dischargedROW 3 EXIT SIGN INOPERATIVE. CHARGED THE BATTERIESSDR MASA2016071912874Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. CHARGED BATTERIES.SDR MASA2016071712868Battery Pack · inoperativeFWD FA FLASHLIGHT INOPERATIVE. R & R THE BATTERY.SDR MASA2016071712867Sign · unknownEMERGENCY EXIT SIGN AT ROW 4 INOPERATIVE. OPS CHECKED GOODSDR MASA2016070812838Battery Pack · dischargedOVERHEAD FWD CEILING EMERGENCY LIGHTS & GALLEY DOOR INOPERATIVE. CHARGED THE BATTERIES.SDR MASA2016070812837Battery Pack · dischargedEMERGENCY EXIT SIGNS AT THE RT BULKHEAD INOPERATIVE, 1ST & COA. CHARGED THE BATTERIES.SDR MASA2016070812836Battery Pack · dischargedALL OVERHEAD EMERGENCY CEILING FLOOD LIGHTS INOPERATIVE EXCEPT ROW 15. CHARGED THE BATTERIES.SDR MASA2016052312700Flashlight · inoperativeFWD F/A FLASHLIGHT INDICATOR LIGHT INOPERATIVE.SDR MASA2016052312698Light · inoperativeALL EMERGENCY EXIT LIGHTS INOPERATIVE.SDR MASA2016042612630Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS INOPERATIVE BATTERY DRAINED. CHARGED BATTERIES.SDR MASA2016042212619Bulb · inoperativeEMERGENCY EXIT SIGN FLOOR LEVEL 14F, ONE BULB INOPERATIVE. REPLACED, OPS CHECKED GOOD.SDR MASA2016042212618Bulb · inoperativeEMERGENCY EXIT SIGN FLOOR LEVEL 14A, ONE BULB INOPERATIVE. REPLACED, OPS CHECKED GOOD.SDR MASA2016030212779Light · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE.SDR MASA2016012712714Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR MASA2015121312616Light · inoperativeEXIT EMERGENCY LIGHT BY PASSENGER DOOR INOPERATIVE.SDR MASA2015111212539Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE, REPLACED.SDR MASA2015100912463Bulb · inoperativeLT FWD OVERWING DOOR EXIT SIGN HAS ONE BULB INOPERATIVE.SDR MASA2015100912462Light · inoperativeROW 15 EMERGENCY CEILING LIGHT INOPERATIVE.SDR MASA2015092012408Battery Pack · dischargedROW 13F EMERGENCY EXIT SIGN INOPERATIVE. CHARGED BATTERY PACK.SDR MASA2015092012407Battery Pack · dischargedROW 13A EMERGENCY EXIT SIGN INOPERATIVE. CHARGED BATTERY PACK.SDR MASA2015091812403Bulb · inoperativeROW 13F EMERGENCY EXIT SIGN HAS ONE BULB INOPERATIVE.SDR MASA2015091812402Bulb · inoperativeROW 13A EMERGENCY EXIT SIGN HAS ONE BULB INOPERATIVE.SDR MASA2015091812401Flashlight · inoperativeFWD F/A'S FLASHLIGHT INOPERATIVE.
Back to N921FJ