N701BR
Service difficulty reports · 165
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 = 'N701BR' 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 = 'N701BR' 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 SWIA201232241Light · inoperativeNR 3 CEILING OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231795Light · inoperativeLEFT FORWARD EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 5534) RELAMPED EMERGENCY LIGHT.SDR SWIA201231726Window · crackedRIGHT WINDOW CRACKED. (FLT 5511) REPLACED RIGHT SIDE WINDOW IAW AMM. PART OFF: NP-139322-6 S/N: 00195H3056SDR SWIA201231557Light · inoperativeONE SECTION OF FLOOR LEVEL EMERGENCY LIGHTS AT ROW 11 IS OUT. (FLT 6459) RELAMPED IN REFERENCE TO AMM.SDR SWIA201231437Power Cable · failedEMERGENCY FLOOR LIGHTING IS OUT. (FLT 5415) REPLACED MID CABIN POWER CABLE IN REFERENCE TO ESPM.SDR SWIA201231438Inverter · failedEMERGENCY SIDEWALL AND FLOOR LIGHTING IS OUT. (FLT 5542) REPLACED NR 2 INVERTER.SDR SWIA201230268Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6485) RELAMPED EMERGENCY LIGHT.SDR SWIA201230208Inverter · failedRIGHT SIDE EXIT ROW LOWER EMERGENCY LIGHT IS INOPERATIVE. (FLT 5605) REPLACED NR 3 EMERGENCY LIGHT INVERTER PER AMM.SDR SWIA201230088Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5234) RELAMPED EMERGENCY LIGHT.SDR SWIA201230087Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5234) RELAMPED EMERGENCY LIGHT.SDR SWIA201229899Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4530) RELAMPED EMERGENCY LIGHT.SDR SWIA201229758Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5611) RELAMPED EMERGENCY LIGHT.SDR SWIA2012021329659Control Unit · malfunctionedFLT 6299, ADG DEPLOYED AFTER TAKEOFF. RESTOWED ADG AND REPLACED ADG AUTO CONTROL UNIT. PN: , SN OFF:SDR SWIA201229459Light · inoperativeNR 2 FORWARD OF RIGHT WING ON FUSELAGE EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229335Light · inoperativeNR 2 RIGHT WING AFT EMERGENCY LIGHT IS OUT. (FLT 5652) RELAMPED EMERGENCY LIGHT.SDR SWIA201229334Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6340) RELAMPED EMERGENCY LIGHT.SDR SWIA201229079Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6250) RELAMPED EMERGENCY LIGHT.SDR SWIA201128710Light · inoperativeFORWARD CEILING EMERGENCY LIGHT IS OUT. (FLT 5484) RELAMPED EMERGENCY LIGHT.SDR SWIA201128463Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128253Light · inoperativeNR 1 AND NR 4 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128115Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (FLT 6477) RELAMPED EMERGENCY LIGHT.SDR SWIA201128106Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6288) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127678Light · inoperativeNR 1 CEILING EMERGENCY LIGHT IS OUT. (FLT 6386) RELAMPED EMERGENCY LIGHT.SDR SWIA201127247Light · inoperativeLEFT WING FORWARD EMERGENCY EXIT LIGHT IS OUT. (FLT 6387) RELAMPED EMERGENCY LIGHT.SDR SWIA201127248Charger · failedRIGHT SIDE FLOOR EMERGENCY LIGHTS AT ROWS 6-8 ARE OUT. (FLT 6503) REPLACED BATTERY PACK CHARGER ASSEMBLY.SDR SWIA201127177Light · inoperativeRIGHT OVERWING MIDDLE EMERGENCY LIGHT IS OUT. (FLT 6442) RELAMPED EMERGENCY LIGHT.SDR SWIA201127135Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127089Light · inoperativeNR 1 CEILING EMERGENCY LIGHT IS OUT. (FLT 5407) RELAMPED EMERGENCY LIGHT.SDR SWIA201126765Light · inoperativeRIGHT AFT EXTERIOR FUSELAGE EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126539Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6229) RELAMPED EMERGENCY LIGHT.SDR SWIA201126374Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6829) RELAMPED EMERGENCY LIGHT.SDR SWIA201126336Light · inoperativeLT WING EXTERIOR AFT EMERGENCY LIGHT IS OUT. (FLT 6818) RELAMPED EMERGENCY LIGHT.SDR SWIA201126063Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6581) RELAMPED EMERGENCY LIGHT.SDR SWIA201125533Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6856) RELAMPED EMERGENCY LIGHT.SDR SWIA201125421Lamp · burned outAFT CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6708) RELAMPED EMERGENCY LIGHT.SDR SWIA201025096Bulkhead · crackedFS 621.0 PRESSURE BULKHEAD FORWARD SIDE CRACKED AT AFT, UPPER CARGO TRACK. (C-CHECK) REPAIR PER REO.SDR SWIA201025248Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPAIRED PER REO.SDR SWIA201024124Handle · wornMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6484) REPLACED DOOR HANDLE ASSEMBLY.SDR CHQA200900117Pressure Switch · faultyFLIGHT 5607, SDF TO IAH - AT FL280 THE CREW RECEIVED AN APU OIL PRESS MESSAGE ON EICAS. THE QRH WAS FOLLOWED AND THE AIRCRAFT DIVERTED TO AEX WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE APU OIL LEVEL LOW. THE APU WAS SERVICED WITH 1QT OF BP2380 SDR CHQA200900116Oil System · lowFLIGHT 5607, CMH TO IAH - AT FL310 THE CREW RECEIVED AN APU OIL PRESSURE MESSAGE ON EICAS. THE CREW FOLLOWED THE QRH AND DIVERTED TO SDF WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE APU OIL LEVEL LOW. THE APU WAS SERVICED WITH 1QT OF BP2380 OIL ISDR CHQA200900078Light · inoperativeDURING INSPECTION THE RIGHT AFT EXTERIOR EMERGENCY LIGHT WAS FOUND TO BE INOP. THE LIGHT WAS RE-LAMPED AND OPERATED NORMALLY.SDR CHQA200900040Wire Harness · defectiveFLIGHT 5650 ELP TO IAH - THE CREW REPORTED THAT ON GEAR RETRACTION THERE WAS A NOSE LANDING GEAR DISAGREE MESSAGE AND THE NOSE LANDING GEAR DOORS INDICATED RED AND THE NOSE LANDING GEAR INDICATED "IN TRANSIT". THE AIRCRAFT CONTINUED ON TO IAH AND LANDED WITHOSDR CHQA200900032Sequence Valve · leakingFLIGHT 5503, SDF TO IAH - UPON GEAR RETRACTION DURING INITIAL CLIMB, THE GEAR WOULD INDICATE FULL UP FOR A FEW SECONDS FOLLOWED BY AMBER HASHED INDICATIONS. THIS REPEATED SEVERAL TIMES ACCOMPANIED BY A LOUD THUMPING. THERE WERE NO CAUTION, WARNING, OR AURAL SDR CHQA200900027Proximity Sensor · looseFLIGHT 5541, LIT TO IAH - UPON GEAR RETRACTION, THE FLIGHT CREW REPORTED A RYTHMIC VIBRATION ACCOMPANIED BY A BRIEF GEAR DISAGREE MESSAGE ON EICAS. THE MESSAGE WENT AWAY BUT THE VIBRATION DID NOT. THE GEAR INDICATION LIGHTS WERE FLASHING AND THE CREW WAS UNASDR CHQA200900016Clamp · looseFLIGHT 5652, ATL TO CLE. DURING DESCENT INTO CLE THE AIRCRAFT ENCOUNTERED ICING CONDITIONS AT APPROXIMATELY 11,000 FT. BETWEEN 8,000 AND 6,000 FT THE FLIGHT CREW RECEIVED AN ICE INDICATION ON EICAS AND TURNED ON THE WING ANTI-ICE AND RECEIVED AN ANTI-ICE DUCSDR CHQA200800185Control Panel · faultedFLIGHT 5601 IAH TO JAX. DURING FLIGHT THE CREW RECEIVED AN E2 REV ICON INTERMITTENTLY. THE REVERSER DID NOT DEPLOY. THE FLIGHT LANDED WITHOUT INCIDENT. THE REVERSER WAS PLACED ON MEL AND THE ACFT WAS RELEASED BACK TO SERVICE. THE MEL WAS CLEARED ON THE 22SDR CHQA200800142Sensor · faultyFLIGHT 5994, RDU TO SDF. DURING CLIMB AT 3,000 FT THE FLAPS WERE SELECTED FROM 3 DEGREES TO ZERO AND THE CREW RECEIVED A FLAP FAIL MESSAGE. THE CREW REPORTED THAT THE LEFT FLAP STOPPED AT 3 DEGREES AND THE RIGHT FLAP STOPPED AT ZERO. MAINTENANCE RIGGED THE SDR CHQA200800140Control Unit · faultyFLIGHT 5994, RDU TO IAH. UPON FLAP RETRACTION FROM FLAPS 8 TO ZERO AFTER TAKEOFF FROM RDU, THE FLIGHT CREW RECEIVED A FLAPS FAIL MESSAGE ON EICAS. THE MESSAGE WAS CONFIRMED AND THE FLAPS WERE FAILED AT 3 DEGREES ON THE LEFT FLAP AND ZERO DEGREES ON THE RIGHTSDR CHQA200800138Bracket · unsecureFLIGHT 5586, RDU TO CLE. UPON FLAP RETRACTION FROM FLAPS 20 TO FLAPS 8 THE CREW RECEIVED A FLAP FAIL MESSAGE. THE MESSAGE WAS CONFIRMED AND THE LT FLAP WAS AT 11 DEGREES WHILE THE RT FLAP WAS AT 10 DEGREES. THE QRH CHECKLIST WAS FOLLOWED AND THE AIRCRAFT LASDR CHQA200800137Flap System · out of rigFLIGHT 5716 - IAH TO JAX. DURING CLIMB WHEN THE FLAPS WERE SELECTED FROM 8 TO 0 THE RT FLAP RETRACTED TO 0 AND LT FLAP FROZE AT 3 DEGREES AND A FLAP FAIL MESSAGE APPEARED ON EICAS. THE APPROPRIATE CHECK LISTS WERE FOLLOWED AND THE FLIGHT RETURNED TO IAH AND
Back to N701BR