N703BR, cancelled Sep 2, 2009
Service difficulty reports · 23
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 = 'N703BR' AND deregistration_id = 'N703BR-2009-09-02' 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 = 'N703BR' AND deregistration_id = 'N703BR-2009-09-02' 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 05056703Warning Light · illuminatedEVENT SUMMARY STATED MACH TRIM FAILURE MSG AND STAB TRIM MSG. WO CA: C/W BOMBARDIER SL 27-083.SDR 050327032Striker · dentedPAX DOOR SEAL STRIKER PLATE DENTED FROM IMPACT WITH DOOR PINS.SDR 050327037Plate · corrodedCARGO LANDING PLATE CORRODED AROUND NUT PLATES ON TOP SURFACE.SDR 050327036Angle · crackedRIGHT OBLIQUE ANGLE AT FS 625 CRACKED.SDR 050327035Angle · crackedLEFT OBLIQUE ANGLE AT FS 625 CRACKED.SDR 050327034Intercostal · crackedINTERCOSTAL CRACK ON OUTBOARD SIDE AT FS 484 RIGHT.SDR 050327033Intercostal · crackedINTERCOSTAL CRACKED ON INBOARD SIDE AT FS 484 LEFT.SDR 050327031Plate · crackedCARGO LANDING PLATE CRACKED AT RIVETS ATTACHING IT TO INTERCOSTALS.SDR 05031703Support · crackedENGINE SUPPORT BEAM CRACKED ON RIGHT HAND LOWER ACCESS PANEL CUTOUT. INBOARD FORWARD EDGE AT 75 IN LENGTH AT RBL 36.2 WATER LINE 111.09SDR 05017703Smoke Detector · intermittentLAV SMOKE INDICATION MOMENTARY ON TAKEOFF. NO SMOKE ODOR PRESENT. MX INSPECTED COALESCER BAGS. NO OIL NOTED.SDR 04328703Smoke Detector · faultyTOILET SMOKE IND ON CLIMB-OUT. ODOR BEGAN SHORTLY AFTER THROTTLES FORWARD FOR T/O NO VISIBLE SMOKE. ODOR WAS MORE OF A MUSTY SMELL, NOT OIL OR BURNING. MX FOUND FAULTY SMOKE DETECTOR. ALSO, REPLACED BOTH COALESCER SOCKS. PERFORMED ENGINE RUNS AT POWER WITSDR 04295703Valve · malfunctionedEVENT SUMMARY STATED LAV SMOKE DETECTOR AURAL WARNING. INSPECT LAV SMOKE DETECTOR CONNECTOR AND WIRING. REMOVED AND REPLACED SPINNER. PERFORM FIM. INSPECT 10TH STAGE DUCT AND DUCTS TO ACM. PERFORMED BORESCOPE INSPECTION. INSTALLED 2 FAN BLADES. REMOVESDR 04292703Line · leakingEVENT SUMMARY STATED THAT SMOKE IN THE LAV INDICATION, EMERGENCY DECLARED. REMOVED AND REPLACED 10TH STAGE BLEED LINES. DID LEAK CHECK.SDR 04289703Smoke · detectedEVENT SUMMARY STATES SMOKE INDICATION/ODOR IN LAV, RTF. IN APPR STATUS.SDR 04287703Acm · smokeEVENT SUMMARY STATES THAT RETURN FROM FLIGHT. SMOKE TOILET CAUTION MSG AFTER TAKEOFF. SMOKE VISIBLE IN TOILET AND AFT CABIN. REMOVED AND REPLACED RT ACM REF MM 21-52-00 AND REMOVED AND REPLACED WATER SEPARATOR SOCK REF MM 21-52-00.SDR 04283703Fan · smokeLAV SMOKE INDICATION WITH FAINT HAZE. SMOKE DISAPPEARED AFTER C/BS PULLED FOR QRH. MX REMOVED AND REPLACED LAV EXHAUST FAN AND SMOKE DETECTOR.SDR 04277703Apu · contaminatedLAV SMOKE INDICATION. DECLARED EMERGENCY RTF, LANDED SAFELY. MX PERFORMED ENGINE RUN WITH APU ON, GOT OIL SMELL AND FOUND OIL IN APU ENCLOSURE.SDR 04187703Bulb · burned outDURING INSPECTION THE LEFT HAND OVERWING EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS REPLACED AND A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED. AIRCRAFT WAS RETURNED TO SERVICE.SDR 03339703Light · inoperativeDURING INSPECTION THE FLOOR EMERGENCY LIGHTS WERE DIM. THE POWER STRIP WAS FOUND INOPERATIVE AND WAS REPLACED. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND THE AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 03202703Light · inoperativeDURING MAINTENANCE INSPECTION, AN EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE EMERGENCY EXIT LAMP. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 03124703Bulb · burned outDURING MAINTENANCE INSPECTION, THE LT OVERWING EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT LIGHT. AN OPERATIONAL CHECK WAS SATISFACTORY AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 02234703LampDuring preflight inspection, the crew reported that the L/H overwing exterior emergency exit light was inoperative. Maintenance personnel removed and replaced the lamp in the L/H overwing exterior emergency exit light. An operational check was satisfactory aSDR 02179703Light · inoperativeDURING PREFLIGHT INSPECTION, THE CREW NOTED THAT THE CEILING EMERGENCY EXIT LIGHTED SIGN WAS INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE LIGHT BULB. AN OPERATIONAL CHECK OF THE EMERGENCY EXIT LIGHTING SYSTEM WAS SATISFACTORY AND THE AIRCRAFT
Back to N703BR, cancelled Sep 2, 2009