N747AS
Service difficulty reports not matched to an aircraft · 202
They name N747AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N747AS' AND registry_match IS NULL 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 = 'N747AS' AND registry_match IS NULL 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 ASAA0410472Floor Support · corrodedOKC - LONGITUDINAL FLOOR SUPPORT HAS CORROSION. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR BEAM IAW SRM.SDR ASAA0410471Floorbeam · corrodedOKC - FLOORBEAM CORRODED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR CHORD SECTION AND REPAIR ANGLES IAW SRM.SDR ASAA0410470Channel · crackedOKC - AFT CARGO BAY U CHANNEL IN HAT STRINGER IS CRACKED. REMOVED DAMAGED U CHANNEL, FABRICATED AND INSTALLED REPLACEMENT U CHANNEL IAW SRM.SDR ASAA0410469Stringer · corrodedOKC - E AND E BAY STRINGER EXFOLIATED. REMOVED DAMAGE, ORDERED AND INSTALLED NEW STRINGER IAW SRM.SDR ASAA0410468Floorbeam · corrodedOKC- FLOORBEAM HAS CORROSION ON FORWARD FLANGE. REMOVED DAMAGE, FLAP PEENED, FABRICATED AND INSTALLED REPAIR STRAP SECTION IAW EA.SDR ASAA0410467Stringer · corrodedOKC - AFT CARGO PIT BILGE AREA CORROSION IN STRINGER FLANGE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR STRINGER SECTION IAW SRM.SDR ASAA0410466Floorbeam · corrodedOKC - STA 328 FLOORBEAM CORRODED AT RBL 11. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND ANGLES IAW SRM.SDR ASAA0410465Skin · chafedOKC - LT WING T/E FORE FLAP HAS CHAFING AREA IN OB EDGE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM.SDR ASAA0410464Skin · chafedOKC- RT WING IB FORE FLAP UPPER SURFACE HAS 6 AREAS THAT ARE CHAFED TO BARE METAL. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM.SDR ASAA0410463Structure · crackedOKC- AFT CARGO DOOR, CENTER SECTION, INTERNAL LIGHTING HOLE HAS .5 INCH CRACK. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM.SDR ASAA0410456Skin · lightning strikeOKC- EXTERIOR SKIN BLEND-OUT FOR LIGHTNING STRIKE IS OUT OF LIMITS. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR FILLERS, DOUBLER, AND TRIPLER IAW SRM.SDR ASAA0410455Floorbeam · corrodedOKC- FLOORBEAM HAS CORROSION ON UPPER AND LOWER SURFACES OF TOP FLANGE. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR FILLER SHIM, AND REPAIR ANGLES IAW SRM.SDR ASAA0410454Floorbeam · corrodedOKC - FLOORBEAM CORRODED. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR FILLER SECTION, SUPPORT ANGLES, AND REPAIR STRAPS IAW SRM.SDR ASAA0410453Floorbeam · corrodedOKC - RT SIDE STA 948 FORWARD FLOORBOARD STRIP ANGLE RBL 44 FASTENER HOLES AND LOWER SIDE FLOORBEAM HAS CORROSION. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR STRAP, FILLER AND WASHERS IAW EA.SDR ASAA0410452Floorbeam · corrodedOKC - CORROSION ON FLOORBEAM TOP FLANGE. REMOVED CORROSION, OUT OF LIMITS IAW SRM. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR ASAA0410435Skin · dentedOKC - AFT CARGO PIT DOOR EDGE DENTED A=1.0, Y=0.120, A/Y=8.3. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM.SDR ASAA0410279Lens · missingANC - FOUND ROW 18 EMERGENCY FLOOR TRACK LIGHT MISSING LAMP IN GALLEY AREA. REPLACED MISSING CLEAR LENS COVER. (M)SDR ASAA0410067Battery · inoperativeANC - DURING INSPECTION, FOUND THE EXIT IDENTIFIER IN THE MID CABIN INOPERATIVE. REPLACED BATTERY AND REPAIRED WIRE, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410066Battery Pack · inoperativeANC- DURING INSPECTION, FOUND THE EMERGENCY FLOOR TRACK LIGHTS ON SEAT PALLET 8-6 INOPERATIVE. REPLACED BATTERY PACK, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410053Battery · not seatedANC - DURING INSPECTION, FOUND THE OVERHEAD EMERGENCY EXIT IDENTIFIER IN THE MID CABIN INOPERATIVE. RESEATED THE BATTERY, THEN EXIT IDENTIFIER OPERATED NORMAL. (M)SDR ASAA0410043Battery Pack · inoperativeANC - DURING INSPECTION, FOUND TRACK LIGHTING INOPERATIVE AT PALLET 9-10. REPLACED BATTERY ON SEAT PALLET 9-10. OPS CHECK GOOD. (M)SDR ASAA0410042Wire · damagedANC - DURING INSPECTION FOUND EMERGENCY EXIT LIGHTING CONTROL CIRCUIT BREAKER WILL NOT TEST. REPAIRED WIRING. OPS CHECK GOOD. (M)SDR ASAA001BCircuit Breaker · inoperativeDURING INSPECTION FOUND, THE EMERGENCY FLOOR PATH LIGHTING ON WITH SWITCH IN ARMED OR OFF POSITION. RESET THE EMERGENCY FLOORPATH LIGHTING CIRCUIT BREAKER THEN LIGHT TESTED NORMAL. (M)SDR ASAA01100MMCircuit Breaker · inoperativeDURING INSPECTION, FOUND THE EMERGENCY FLOORPATH LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION.RESET THE EMERGENCY FLOORPATH LIGHTING CIRCUIT BREAKER THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410040Circuit Breaker · inoperativeANC- DURING INSPECTION, FOUND THE EMERGENCY FLOOR PATH LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. RESET THE EMERGENCY FLOOR PATH LIGHTING CIRCUIT BREAKER THEN LIGHTS TESTED NORMAL. (M)SDR ASAA001CBattery Pack · inoperativeDURING INSPECTION, FOUND THE EMERGENCY FLOORPATH LIGHING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. RESET BATTERY PACKS ON PALLETS 5-12, 6-11, 9-11, 9-5, 7-6, AND 10-11 THEN LIGHTS TESTED NORMAL. (M)SDR ASAA01100LLBattery Pack · inoperativeDURING INSPECTION FOUND THE EMERGENCY FLOORPATH LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. RESET BATTERY PACKS ON PALLETS 5-12, 6-11, 9-11, 9-5, 7-6, AND 10-11 THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410038Battery Pack · inoperativeSEA - DURING INSPECTION, FOUND THE EMERGENCY FLOOR PATH LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. RESET BATTERY PACKS ON PALLETS 5-12, 6-11, 9-11, 9-5, 7-6, AND 10-11 THEN LIGHTS TESTED NORMAL. (M)SDR ASAA20041Light · inoperativeSEA - DURING INSPECTION FOUND MID CABIN OVERHEAD EXIT SIGN INOPERATIVE AND FLOOR TRACK LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. REPLACED MID CABIN OVERHEAD SIGN BATTERY P/N 86210144 PACK AND TRACK LIGHTING CONTROL MODULE P/N 873203041 THEN LIGHTSSDR ASAA0410037Battery · dischargedSEA - DURING INSPECTION, FOUND MID CABIN OVERHEAD EXIT SIGN INOPERATIVE AND FLOOR TRACK LIGHTING ON WITH SWITCH IN 'ARMED' OR 'OFF' POSITION. REPLACED MID CABIN OVERHEAD SIGN BATTERY PACK AND TRACK LIGHTING CONTROL MODULE (P/N 873203041) THEN LIGHTS TESTED NOSDR ASAA0310644Battery · dischargedANC - DURING INSPECTION, FOUND THE EMERGENCY EXIT IDENTIFIER ON THE SMOKE BARRIER INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0310545Transmitter · inoperativeSEA - DURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROWS 8-10 AND 14-16 INOPERATIVE. REPLACED BATTERY PACK (P/N 8821004) AT ROW 14 AND TRANSMITTER (P/N 883200312) AT ROW 11, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310543Battery Pack · inoperativeSEA - DURING RECON INSPECTION, FOUND BATTERY PACKS AT SEAT PALLETS 5-12 AND 8-9 INOPERATIVE. REPLACED BATTERY PACKS, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310005Control Module · inoperativeFOUND EMERGENCY TRACK LIGHTING ILLUMINATED ON DESCENT AND THEN EXTINGUISHED PRIOR TO LANDING. REMOVED AND REPLACED CENTER CONTROL MODULE, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210381Module · faultyANC - DURING TAXI, EMERGENCY FLOOR TRACK LIGHTING FLICKERED ON AND OFF AFTER LANDING. REMOVED AND REPLACED AFT CONTROL MODULE, THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210293Battery · dischargedANC - DURING DESCENT INTO ANC, EMERGENCY FLOOR TRACK LIGHTING ILLUMINATED ON PALLETS 9-3 AND 7-12. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES AT PALLETS 9-3 AND 7-12, THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210260Door Frame · crackedPAE - DURING SCHEDULED C-CHECK, FOUND AFT CARGO DOOR FRAME AT BS 787, RIGHT BUTTOCK LINE 40 CRACKED. REPAIRED CRACK PER EA. (M)SDR ASAA0210244Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME AT BS 685, RBL 68 CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PER EA. (M)SDR ASAA0210243Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME AT BS 685, LBL 68 CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PER EA. (M)SDR ASAA0210251Frame · dentedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME INNER CHORD AT BS 808, STRINGER 25L DENTED. REMOVED AND REPLACED FRAME PER SRM. (M)SDR ASAA0210250Tee Fitting · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND AFT CARGO DOOR NR 5 T-ANGLE AT BS 808, RBL 65 CRACKED 1 INCH. FABRICATED REPAIR ANGLE PER EA. (M)SDR ASAA0210249Keelbeam · chafedPAE - DURING SCHEDULED C-CHECK, FOUND KEEL BEAM AT BS 720-727, LBL 7 CHAFED. REMOVED AND REPLACED KEEL BEAM PER EA. (M)SDR ASAA0210248Keelbeam · damagedPAE - DURING SCHEDULED C-CHECK, REQUIRED KEEL BEAM ACCESS, CUT OUT OF SKIN PANEL AT BS 727-727 PLUS 16, LEFT BUTTOCK LINE 7. (M)SDR ASAA0210246Keelbeam · crackedPAE - DURING SCHEDULED C-CHECK, FOUND KEEL BEAM FLANGE AT BS 727-735, LBL 7 CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PER SRM. (M)SDR ASAA0210245Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 727A, STRINGER 27R CORRODED. REMOVED CORRODED, FABRICATED AND INSTALLED REPAIR PER SRM. (M)SDR ASAA0210233Latch · out of adjustDURING SCHEDULED C CHECK, FOUND LT OVERWING EMERGENCY EXIT HATCH HARD TO OPEN. ADJUSTED LT OVERWING EXIT DOOR IAW MM, THEN DOOR OPERATED NORMAL.SDR ASAA0210222Support Fitting · corrodedDURING SCHEDULED C CHECK, FOUND FAIRING SUPPORT ANGLE BODY STATION 676, RIGHT BUTTOCK LINE 17, RIGHT BUTTOCK LINE 44, CORRODED. REMOVED AND REPLACED SUPPORT ANGLE IAW SRM.SDR ASAA0210223Skin · gougedDURING SCHEDULED C CHECK, FOUND SKIN PANEL AT BODY STATION 312-328, STRINGER 17L-18L GOUGED. INSTALLED DOUBLER AND TRIPLER IAW EA.SDR ASAA0210225Skin · wornDURING SCHEDULED C CHECK, FOUND LEADING EDGE SKIN AT NR 2 SLAT ACTUATOR CUTOUT AT WING STATION 409-447 WORN. REMOVED AND REPLACED SKIN IAW SRM.SDR ASAA0210224Structure · damagedDURING SCHEDULED C CHECK, FOUND NR5 SLAT AT WING STATION 227-329 DAMAGED. REMOVED AND REPLACED NR5 SLAT.
Back to N747AS