Britten Norman BN-2B-20
Service difficulty reports · 59
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'BN2B20' 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 aircraft_model_key = 'BN2B20' 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 AU960287Hose · collapsed(AUS) RH ENGINE INDUCTION HOSE COLLAPSED DUE TO INTERNAL WIRE SEPARATING FROM THE HOSE - SLIGHT CORROSION WAS ALSO FOUND ON THEWIRE IN THE AFFECTED AREA - FOUND DURING INSPECTION IAW AD/BN2/57- LH ENGINE HOSE WAS INSPECTED AND FOUND TO BE SERVICEABLE - LHENGISDR AU960242Hose · faulty(AUS) LH AND RH ENGINE AIR INDUCTION HOSES FAULTY AS PER AD/BN2/57 AND SB BN2-95 - LH ENGINE HOSE WIRE SEPARATING - RH ENGINE HOSE WIRE SEPARATING AND HOSE PARTIALLY COLLAPSED - BOTH HOSES WERE SERVICEABLE AT LAST 50 HOUR SERVICINGSDR AU960339Pump · failed(AUS) RH WING TIP FUEL TRANSFER PUMP FAILEDSDR AU960105Gascolator · leaking(AUS) RH ENGINE GASCOLATOR LOOSE DUE TO RETAINER ARM MOVING AND ALLOWING BOWL TO MOVE SIDEWAYS - FUEL LEAKING FROM GASCOLATOR -SUSPECT CAUSED BY OVERTORQUEING OF THE RETAINER ARM CAUSING DISTORTION OF THE ARMSDR AU960037Hose · failed(AUS) LH ENGINE INDUCTION AIR HOSE BETWEEN AIR BOX AND FUEL CONTROL COLLAPSED - RH ENGINE INDUCTION HOSE INSPECTED AND WAS FOUND TOBE ALSO CLOSE TO FAILURE - NUMEROUS OTHER FAILURES RECORDED IN FLEETSDR AU960030Hose · failed(AUS) RH ENGINE INDUCTION HOSE BETWEEN AIR FILTER AND FUEL SERVO UNIT INTERNAL WIRE DISPLACEDSDR AU960029Hose · failed(AUS) LH ENGINE INDUCTION HOSE COLLAPSEDSDR AU960028Hose · faulty(AUS) RH ENGINE INDUCTION HOSE COLLAPSED IN MID SECTION - INNER WIRE SEPARATED FROM OUTER WALLSDR AU960003Hose · collapsed(AUS) LH ENGINE INDUCTION HOSE BETWEEN ALTERNATE AIR BOX AND FUEL CONTROL COLLAPSED - SUSPECT CAUSED BY FAULTY BATCH OF SCAT HOSES
Back to Britten Norman BN-2B-20