N750AN
Service difficulty reports · 248
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 = 'N750AN' 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 = 'N750AN' 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 AALA20120407006Lamp · burned outSEAT 38G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 38G EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120407005Lamp · burned outSEAT 34C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 34C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120407004Lamp · burned outSEAT 24C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 24C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20120329007Light · inoperativeSEAT 12D EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 12D EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120328014Light · inoperativeLEFT NUMBER 3 DOOR CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR CEILING EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120328013Light · inoperativeSEAT 31C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31C. OPS CHECK NORMAL.SDR AALA20120118TUL08Lens · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPS CHECK NORMAL.SDR AALA20120118TUL07Lens · missingESCAPE PATH LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 26C. OPS CHECK NORMAL.SDR AALA20120118TUL06Lens · missingESCAPE PATH LIGHT AT SEAT 21G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 21G. OPS CHECK NORMAL.SDR AALA20120110LHR02Lens · missingESCAPE PATH LIGHT AT SEAT 20G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 20G. OPS CHECK NORMAL.SDR AALA20120110LHR01Battery Pack · dischargedF5 GALLEY FLOOR PROXIMITY ESCAPE PATH LIGHT AT LEFT AND RIGHT NUMBER 1 DOOR. REPLACED BATTERY PACK AND CHARGER M33093AT DOOR 1 LEFT FORWARD POSITION. OPS CHECK NORMAL.SDR AALA20110908TUL03Lens · missingSEAT 20C EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 20C EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110908TUL02Lens · missingSEAT 26G EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 26G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110908DFW06Light · out of alignmentRIGHT NUMBER 3 DOOR, CEILING AISLE EMERGENCY PATH LIGHT IN GRILL NOT ALIGNED. REPOSITIONED RIGHT NUMBER 3 DOOR OVERHEAD CEILING AISLE EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110908DFW05Battery Pack · dischargedSEAT ROWS 30 TO 45, EMERGENCY PATH LIGHTS EXTINGUISHED WITHIN 3 MIN. REPLACED M33401 BATTERY PACK FOR EMERGENCY LIGHT AT ROWS 30-45. OPS CHECK NORMAL.SDR AALA20110908DFW04Lens · out of positionLENS FOR SEAT 44G EMERGENCY PATH LIGHT REVERSED. REPOSITIONED LENS FOR SEAT 44G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110908DFW03Lens · out of positionLENS FOR SEAT 33C EMERGENCY PATH LIGHT REVERSED. REPOSITIONED LENS FOR SEAT 33C EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110908DFW02Light · missingSEAT 20C EMERGENCY PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 20C EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110908DFW01Light · missingSEAT 26G EMERGENCY PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 26G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110803MIA03Seal · brokenLEFT NUMBER 1 EMERGENCY LIGHT SEAL BROKEN. REPLACED SEAL. OPS CHECK NORMAL.SDR AALA20110803MIA02Lens · missingCENTER AISLE BETWEEN THE 2L AND 2R WALL MOUNTED EMERGENCY LIGHT MIDDLE IS MISSING LENS. REPLACED LENS AT CENTER AISLE MIDDLE POSITION WALL MOUNTED EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110803MIA01Lens · missingTHE 33C SEAT MOUNTED EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR 33C SEAT MOUNTED EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110130DFW03Light · inoperativeLEFT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-SECURED LIGHT. OPS CHECK NORMAL.SDR AALA20110130DFW06Light · inoperativeROW 40C ESCAPE PATH LIGHT VERY DIM. REPLACED LAMP FOR ROW 40C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110130DFW05Light · inoperativeLEFT NUMBER 3 DOOR AFT SIDEWALL ESCAPE PATH LIGHT HAS BULBS INOPERATIVE. REPLACED LAMPS FOR LEFT NUMBER 3 DOOR AFT SIDEWALL ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110130DFW04Lens · missingROW 39G EPL LENS MISSING. INSTALLED LENS 39G.SDR AALA20101231JFK01Cover · missingFIRST CLASS CLOSET MINI WALL LIGHT COVER MISSING. REPLACED LIGHT ASSEMBLY AT FIRST CLASS COAT CLOSET. OPS CHECK NORMAL.SDR AALA20101111DFW07Light · inoperativeEMERGENCY LIGHT IN LEFT CEILING FROM ROWS 4A TO 12A INOPERATIVE. RESET EMERGENCY LIGHT SYSTEM AT LEFT CEILING ROWS 4A TO 12A. OPS CHECK NORMAL.SDR AALA20101026MIA03Light · inoperativeSEAT 22C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. OPS CHECKS NORMAL.SDR AALA20101026MIA02Light · inoperativeSEAT 21C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21C. OPS CHECKS NORMAL.SDR AALA20101026MIA01Light · inoperativeSEAT 20C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 20C. OPS CHECKS NORMAL.SDR AALA20101007DFW08Lens · missingPATHWAY EMERGENCY LIGHT AT SEAT 21G CLEAR LENS IS MISSING. REPLACED MISSING LENS. OPS CHECKS NORMAL.SDR AALA20101007DFW07Connector · loosePATHWAY EMERGENCY LIGHTS FROM SEAT 36 TO 45 ON BOTH SIDES ARE INOPERATIVE. RECONNECTED AND SECURED LOOSE CONNECTOR. OPS CHECKS NORMAL.SDR AALA20101007DFW06Light · inoperativeEMERGENCY LIGHT ON LEFT SIDE OF BUSINESS CLASS/TOURIST CLASS WALL PARTITION IS INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20101007DFW05Light · missingPATHWAY EMERGENCY LIGHT AT SEAT 21G IS MISSING BULB. REPLACED LAMP FOR PATHWAY EMERGENCY LIGHT AT SEAT 21G. OPS CHECKS NORMAL.SDR AALA20101007DFW04Light · crackedRIGHT SIDE FORWARD GALLEY EMERGENCY LIGHT ASSEMBLY CRACKED AND LENS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECKS NORMAL.SDR AALA20101007DFW03Light · crackedLEFT SIDE FORWARD GALLEY EMERGENCY LIGHT ASSEMBLY CRACKED AND LENS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECKS GOOD.SDR AALA20100802TUL22Guard · damagedROW 43C ESCAPE PATH LIGHT GUARD IS DAMAGED. REPLACED GUARD FOR ESCAPE PATH LIGHT AT ROW 43C. OPS CHECKED NORMAL.SDR AALA20100802TUL21Lens · missingRIGHT NUMBER 1 DOOR GALLEY ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR RIGHT NUMBER 1 DOOR GALLEY ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100403DFW03Guard · brokenFORWARD FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. REPLACED SWITCH GUARD AT FORWARD FLIGHT ATTENDANT EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100112DFW03Light · inoperativeEMERGENCY LIGHT AT SEAT 26G INOPERATIVE. RELAMPED SEAT 26G EMERGENCY LIGHT.SDR AALA20100112DFW02Light · inoperativeEMERGENCY LIGHT AT SEAT 34G INOPERATIVE. RELAMPED SEAT 34G EMERGENCY LIGHT.SDR AALA20100112DFW01Lens · missingEMERGENCY LIGHT AT SEAT 32C MISSING LENS. REPLACED LENS.SDR AALA20091212DFW02Light · inoperativeEMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR CEILING INOPERATIVE. REPLACED LIGHT.SDR AALA20091212DFW03Light · inoperativeEMERGENCY LIGHT AT SEAT ROW 22C INOPERATIVE. REPLACED LAMP.SDR AALA20091212DFW01Light · inoperativeEMERGENCY LIGHT AT SEAT 36C HAS ONE BULB INOPERATIVE. REPLACED LAMP.SDR AALA20091102DFW01Light · inoperativeEMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 31G. OPS CHECKS NORMAL.SDR AALA20091008MIA04Lamp · burned outEMERGENCY LIGHT AT MID GALLEY INOPERATIVE. RELAMPED EMERGENCY LIGHT, SYSTEM CHECKS NORMAL.SDR AALA20091008MIA03Lamp · burned outEMERGENCY LIGHT AT SEAT ROW 10 RIGHT CEILING INOPERATIVE. REPLACED LAMP, SYSTEM OPS CHECKS NORMAL.SDR AALA20091008MIA02Light · inoperativeAFT GALLEY EMERGENCY LIGHT INOPERATIVE BETWEEN JUMP SEATS. RELAMPED EMERGENCY LIGHT, CHECKS NORMAL.
Back to N750AN