N506DA, cancelled Jul 18, 2002
Service difficulty reports · 61
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 = 'N506DA' AND deregistration_id = 'N506DA-2002-07-18' 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 = 'N506DA' AND deregistration_id = 'N506DA-2002-07-18' 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 DL72L950987Cowl · wornDURING INITIAL INSPECTION OF NR 1 ENGINE NOSE COWL. FOUND FORWARD BULKHEAD OUTER ANGLE AT THE 9 O'CLOCK POSITION WITH ELONGATED BOLT HOLES. REPAIRED PER SRM 54-10-3 FIG. 3.SDR DL72L951072Cowl · wornDURING SHOP INSPECTION, NR 1 ENGINE NOSE COWL WAS FOUND WITH WEAR DAMAGE TO AFT FRAME AT THE 4 AND 9 O'CLOCK POSITIONS. REPAIRED PER SRM 54-10-3 FIG 3.SDR DL72L951011Nose Cowl · wornDURING SHOP INSPECTION, FOUND KNIFE EDGE DAMAGE TO TRAILING EDGE LANDING AREA TO BE WORN AT, STATION 99.25 OF NOSE COWL. REPAIRED DAMAGE PER, SRM 54-10-3 FIG NR 3.SDR DL72L951004Nose Cowl · wornDURING SHOP INSPECTION, FOUND KNIFE EDGE DAMAGE TO THE FRAME AREA AT STATION 99.25 OF ENGINE INTAKE COWL. REPAIRED DAMAGE PER SRM 54-10-3 FIG 3.SDR DL72L950985Nose Cowl · gougeGOUGE IN NOSE LIP SKIN OF NR 1 ENGINE NOSE COWL, AT 1:30 POSITION. REPAIRED PER SRM 54-30-3.SDR DL72L950912Nose Cowl · crackedDURING SHOP INSPECTION, A CRACK WAS FOUND IN THE WEB AT NAC STA 77.50 AT 7 O'CLOCK POSITON OF ENGINE NOSE COWL. REPAIRED SRM 54-10-3 FIG 3.SDR DL72L950911Nose Cowl · crackedDURING SHOP INSPECTION, A CRACK WAS FOUND ON OUTER ANGLE AT FORWARD BULKHEAD 6 O'CLOCK POSITION, ON ENGINE NOSE COWL. REPAIRED DAMAGE PER SRM 54-10-3 FIG 3.SDR DL72L950848Gusset · crackedTHE RT TORQUE BOX HORIZONTAL BEAM GUSSET AT FS 1273 WAS FOUND CRACKED. THE GUSSET WILL BE REPLACED IN ACCORDANCE WITH B727 S/B 53-0129 REV. 4.SDR DL72L950782Slat · crackedNR 6 SLAT CRACKED AT ACT. MOUNT BOLT I/B SIDE (.50 INCH). FOUND DURING C-1 LETTER CHECK TPAMM. REPAIRED PER MM 57-54-0 PG 803.SDR DL72L950779Slat · crackedFOUND DURING C-1 LETTER CHECK - .25 INCH CRACK AT NR 3 L/E SLAT BELOW TAI TELESCOPING ROD. REPAIRED PER MM 57-54-0 FIG 805A.SDR DL72L950778Skin · crackedFOUND DURING C-1 LETTER CHECK - 1 INCH CRACKED VERTICAL STAB, OUTER SKIN AT STR 10. REPAIRED PER MM 55-30-0 PG 801.
Back to N506DA, cancelled Jul 18, 2002