ACCOMPLISHED MAJOR REPAIR/REPLACEMENT OF RH BODY LANDING GEAR LOWER BEARING CAP DUE TO TH - [SDR UIEA2026092300913](https://openairdocs.org/sdr/UIEA2026092300913.md): Skin · dented · Sep 25, 2026 · N404KZ · Boeing 747481F · Trailing Edge Flaps > RH WING INBOARD AND AFT FLAP LOWER SURFACE HAS A DENT ABOUT WBL 340.(
ACCOMPLISHED MAJOR REPAIR OF RH INBOARD AND AFT FLAP LOWER SURFACE. HOT-BONDED METAL-TO-METAL REPAIR IAW SRM 57-53-01-2R-1 REPAIR 1 DETAIL III FIG 201, SHEET 4 TABLE III FIG 201, SHEET 10 - [SDR UIEA2026082800820](https://openairdocs.org/sdr/UIEA2026082800820.md): Position Unit · faulted · Aug 28, 2026 · N404KZ · Boeing 747481F · Landing Gear Position and Warning > AFTER TAKEOFF ON INITIAL CLIMB, GEAR TILT, EICAS MSG. RT BODY GEAR DID NOT RETRACT AND TILT INDICATION. COMPLETED CHECKLIST. MSG APPEARED AFTER GEAR RETRACTION STARTED. R & R RT BODY GEAR TRUCK POSITIONER IAW AMM 32-13-15/401 & IPC 32-13-11-01. OPS & LEAK CH - [SDR UIEA2026062800550](https://openairdocs.org/sdr/UIEA2026062800550.md): Wire · damaged · Jun 27, 2026 · N404KZ · Boeing 747481F · Fire Protection System Wiring > FIRE APU WARNING MSG. DISCHARGED BOTTLE. REF WDM 26-15-11-1 INSPECTED AND FOUND W720-452-18R AND W720-451-18R SHORTED TO EACH OTHER UNDER CLAMP. REPAIRED WIRES PER SWPM 20-30-12. FIRE SYSTEM TEST PASSED FOR APU LOOPS A ND B PER AMM 26-15-00-735-009.
) - [SDR UIEA2024081200826](https://openairdocs.org/sdr/UIEA2024081200826.md): Hydraulic System · leaking · Aug 12, 2024 · N404KZ · Boeing 747481F · Hydraulic System, Main > RTB - AFTER TAKEOFF. SYS 4 HYDS FAILED. FLUID LEVEL 0. A/C WOULD NOT PRESSURIZE. DURING FUEL DUMP FOR RETURN. SYS 1 LOST ALL REMAINING FLUID. SYS 2 HYD FLUID LEVEL DECREASING (DID NOT GO TO 0). ON LANDING. FOUND LH MLG WHEELS 7 & 8 BLOWN. R/R #7 & #8 IA - [SDR UIEA2023120200972](https://openairdocs.org/sdr/UIEA2023120200972.md): Seal · unknown · Dec 2, 2023 · N404KZ · Boeing 747481F · Engine Oil System (Airframe Furnished) > ENGINE 4 OIL QUANTITY 0% IN FLIGHT(OIL LEAKING AT IDG ENG #4. REMOVED THE IDG IAW AMM 24-11-01. REPLACED IDG CARBON SEAL ASSY IAW AMM 72-64-02-404-018-J00 REV 109. PERFORMED ENG #4 RUN UP TO 81% N2 FOR 16 MINUTES IAW AMM 71-00-00 REV 109, SATISFACTORY. NO O - [SDR UIEA2023022400192](https://openairdocs.org/sdr/UIEA2023022400192.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Engine Exhaust System > NO.4 ENG LH T/R OPEN ACTUATOR ATT POINT BOLT HOLE FOUND ELONGATED.(
NO.4 ENG LH T/R OPEN ACTUATOR ATT POINT REPAIRED IAW CMM 78-32-02 REV.62
) - [SDR UIEA2023022300191](https://openairdocs.org/sdr/UIEA2023022300191.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - O/B AFT FLAP O/B UPPER ACCESS PANEL FOUND DEEP CHAFING MARK ABOVE AN OLD REPAIR(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 2
) - [SDR UIEA2023022300190](https://openairdocs.org/sdr/UIEA2023022300190.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - O/B AFT FLAP O/B UPPER ACCESS PANEL FOUND DEEP CHAFING MARK(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 4
) - [SDR UIEA2023022300189](https://openairdocs.org/sdr/UIEA2023022300189.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - O/B AFT FLAP O/B UPPER ACCESS PANEL EXISTING REPAIR DOUBLER HAS A DEEP CHAFING MARK(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 4
) - [SDR UIEA2023022300176](https://openairdocs.org/sdr/UIEA2023022300176.md): Power Supply · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Lighting System > M5169 EMER LT BATTERY PACK CAPACITY TEST FAILED(M5169 EMER LT POWER SUPPLY REPLACED AND INSTALLATION TEST NORMAL IAW AMM 33-51-04 REV 106, 15 NOV 2022
) - [SDR UIEA2023022200175](https://openairdocs.org/sdr/UIEA2023022200175.md): Support Ring · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Engine Exhaust System > NO.4 ENG L/H T/R AFT CASCADE SUPPORT RING 11 O'CLOCK FOUND CRACK FORWARD OF BOLT HOLE.(SUPPORT RING REPLACEMENT CARRIED OUT AS PER ATLAS AIR EO: 1978A084 REV.3 PART 1.
) - [SDR UIEA2023022200169](https://openairdocs.org/sdr/UIEA2023022200169.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > LHW - AFT I/B FLAP O/B UPPER ACCESS PNL HAS CHAFING MARK.(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 2
) - [SDR UIEA2023022200168](https://openairdocs.org/sdr/UIEA2023022200168.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > LHW - AFT I/B FLAP O/B SECTION LOWER SURFACE HAS A DENT MARK(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 2
) - [SDR UIEA2023022200167](https://openairdocs.org/sdr/UIEA2023022200167.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW O/B FORE FLAP O/B TOP PNL FOUND 1EA DENT(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 2
) - [SDR UIEA2023022200166](https://openairdocs.org/sdr/UIEA2023022200166.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW O/B FORE FLAP I/B TOP PNL NEAR I/B EDGE AREA FOUND PUNCTURED(PERFORMED METAL TO METAL HOTBOND REPAIR AS PER SRM 51 - 70 - 10 REPAIR 4
) - [SDR UIEA2023022100163](https://openairdocs.org/sdr/UIEA2023022100163.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - I/B FORE FLAP UPPER SURFACE FOUND DELAM (APPROX 140" FROM I/B AND 16"FROM T/E)(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022100158](https://openairdocs.org/sdr/UIEA2023022100158.md): Shear Tie · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RH STA 1000 FRONT SPAR SHEAR TIE RBL 33.99" 1EA CRACK WAS FOUND APPROX 1.5".(CRACK SHEAR TIE REPLACEMENT CARRIED OUT AS PER ATLAS AIR EO 4453C024 PART 8 AND RI NO. RI-53-43-16092 REV.A
) - [SDR UIEA2023022100156](https://openairdocs.org/sdr/UIEA2023022100156.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > APU COMPT TAIL CONE INTERNAL LH FS 2753 WL 359 SUPPORT FRAME CRACK.(FRAME CRACK AREA REPAIRED AS PER RI NO. RI-53-80-16075 REV.A
) - [SDR UIEA2023022100155](https://openairdocs.org/sdr/UIEA2023022100155.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > APU FIREWALL STA 2658 FWD FACE #2 STIFFENER (COUNT FROM BOTTOM) FOUND L/H O/B END CRACKED.(CRACK AREA REPAIRED AS PER RI NO. RI-53-83-16077 REV.A
) - [SDR UIEA2023022100152](https://openairdocs.org/sdr/UIEA2023022100152.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > APU FIREWALL AT STA 2658 FWD FACE #2 STIFFENER (COUNT FROM BOTTOM) FOUND END CRACKED.(CRACK AREA REPAIRED AS PER RI NO. RI-53-83-16077 REV.A
) - [SDR UIEA2023022100151](https://openairdocs.org/sdr/UIEA2023022100151.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - I/B T/E MID FLAP L/E FIXED FAIRING AT MID EXTERIOR SURFACE FOUND DELAM(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022100150](https://openairdocs.org/sdr/UIEA2023022100150.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > LHW - I/B FORE FLAP L/E FOUND DELAMINATION 128" APPROX FROM O/B EDGE(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022100149](https://openairdocs.org/sdr/UIEA2023022100149.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > LHW O/B T/E MID FLAP L/E FAIRING EXTERIOR SURFACE AT MID AREA DELAMINATED(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022100148](https://openairdocs.org/sdr/UIEA2023022100148.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - I/B FORE FLAP UPPER SURFACE FOUND DELAM (APPROX 50" FROM I/B 16" FROM T/E)(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022100147](https://openairdocs.org/sdr/UIEA2023022100147.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > RHW - O/B MID FLAP O/B SECTION UPPER FIXED PNL SUPPORT BRACKET ATT SCREW HOLE ELONGATED(PERFORMED COMPOSITE HOTBOND REPAIR AS PER SRM 51-70-07 PAR.5A
) - [SDR UIEA2023022000143](https://openairdocs.org/sdr/UIEA2023022000143.md): Lamp · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Emergency Lighting > L1 DOOR EMER LT L1854 FOUND INOP.(L1 DOOR EMER LT LAMP REPLACED AND TEST NORMAL REF AMM 33-51-05.
) - [SDR UIEA2023022000142](https://openairdocs.org/sdr/UIEA2023022000142.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Engine Exhaust System > NO.3 ENG L/H T/R IDG SERVICE DOOR AFT 2EA LATCH ATT SKIN FOUND WEAR.(2EA WEAR SKIN AREA REPAIRED AS PER ST ENGINEERING CMM 78-32-02 REPAIR 45.
) - [SDR UIEA2023022000141](https://openairdocs.org/sdr/UIEA2023022000141.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > FX SECTION 48 FROM STA 2747 TO 2753 AND BETWEEN WL 357 AND WL 361 FOUND SKIN CRACK.(SKIN CRACK AREA REPAIRED AS PER RI NO. RI-53-80-16075 REV.A
) - [SDR UIEA2023022000140](https://openairdocs.org/sdr/UIEA2023022000140.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > FX FUSELAGE LOWER SKIN STA 2120-2140 STR 44R-45R FOUND 1EA LIGHTNING STRIKE.(SKIN LIGHTNING STRIKE AREA REPAIRED AS PER SRM 53-00-01-2R-9 REPAIR 9.
) - [SDR UIEA2023022000139](https://openairdocs.org/sdr/UIEA2023022000139.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > LH BS720 1EA CRACK WAS FOUND ON THE FWD CHANNEL OF THE UPPER DECK TENSION TIE APPROX 1/2" IN LENGTH AT RADIUS AREA.(CHANNEL REPAIRED AS PER SRM 53-20-30-2R-1 REPAIR 1. THIS REPAIR WAS CATEGORY B.
) - [SDR UIEA2023022000138](https://openairdocs.org/sdr/UIEA2023022000138.md): Rivet · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Flight Control System > NO.5 FLAP TRACK CANOE FAIRING DRIVE LINK RIVETS FOUND LOOSE.(LOOSE RIVETS REPLACEMENT AS PER ATLAS AIR EO NO.4427A040 REV.9 PART 1 AND CMM 27-51-93.
) - [SDR UIEA2023022000137](https://openairdocs.org/sdr/UIEA2023022000137.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Powerplant System > NO.3 ENG R/H CORE COWL PRECOOLER EXHAUST RIVET HOLES FOUND CRACK (2EA).(CRACK AREA REPAIRED AS PER SRM 54-45-01-2R-4 REPAIR 4 FIG 201.
) - [SDR UIEA2023021700132](https://openairdocs.org/sdr/UIEA2023021700132.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > EMP - APU COMPT RH FRAME AT STA 2664 WL 305 FOUND CRACKED.(CRACK AREA REPAIRED AS PER SRM 53-80-07-2R-1 REPAIR 1.
) - [SDR UIEA2023021600125](https://openairdocs.org/sdr/UIEA2023021600125.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > FX LH BODY FAIRING #191KL INTERCOSTAL AT STA 1240 UPPER AND LOWER FLANGE FOUND CRACK.(INTERCOSTAL UPPER AND LOWER FLANGE REPAIRED AS PER RI NO. RI-53-40-16059 REV.A
) - [SDR UIEA2023021600124](https://openairdocs.org/sdr/UIEA2023021600124.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Fuselage Structure (General) > FX RH BODY FAIRING #192KR INTERCOSTAL AT STA 1240 UPPER AND LOWER FLANGE FOUND CRACK.(UPPER & LOWER FLANGE REPAIRED AS PER RI NO. RI-53-40-16060 REV.A
) - [SDR UIEA2023021600122](https://openairdocs.org/sdr/UIEA2023021600122.md): Shear Tie · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Wing Structure > LH STA 1000 FRONT SPAR SHEAR TIE LBL 57.5 1EA CRACK WAS FOUND APPROX 1.5".(CRACK SHEAR TIE REPLACEMENT CARRIED OUT AS PER ATLAS AIR EO: 4453C024 PART 5.
) - [SDR UIEA2023021400117](https://openairdocs.org/sdr/UIEA2023021400117.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Doors > BULK CARGO DOOR (P/N: 65B01857-26; S/N: 001338) OUTER SKIN FWD LOWER CORNER DENT (EO: 1952A260-4).(DENT AREA REPAIRED AS PER SRM 52-00-01-2R-9 REPAIR 9 FIG 201.
) - [SDR UIEA2023021300109](https://openairdocs.org/sdr/UIEA2023021300109.md): None · none · Feb 28, 2023 · N404KZ · Boeing 747481F · Doors > APU RH COMPT DOOR #1 LATCH CUTOUT FOUND CRACKED.(CRACK AREA REPAIRED AS PER SRM 52-40-01-2R-5 REPAIR 5 FIG 201.
) - [SDR UIEA2022011800056](https://openairdocs.org/sdr/UIEA2022011800056.md): None · none · Jan 18, 2022 · N404KZ · Boeing 747481F · Cargo/Baggage Doors > MAIN DECK CARGO DOOR STA 1899.05-1912.90 ABOUT ACCESS HOLE, OUTER REVERSE DENT W=1" D=3/323 AND INSIDE SKIN GOUGE 1/4"X3/4" D= 1/32"(FOR INSIDE GOUGE, SMOOTHED OUT PER SRM 52-3001 FOR REVERSE DENT. REMOVED EXISTING DOUBLER & SMOOTHED OUT DENT TO FLUSH PER S - [SDR UIEA2021020900261](https://openairdocs.org/sdr/UIEA2021020900261.md): Skin · dented · Feb 6, 2021 · N404KZ · Boeing 747481F · Trailing Edge Flaps > DENT - SKIN, FOUND R/H WING OUTBD MID FLAP TOP PANEL UPPER SURFACE DENT AT WBL 536(
REMOVED THE DAMAGED MATERIAL AND CLEANED, MEASURED THE DAMAGE AREA (DIA: 1", 5" FROM L/E, 22" FROM INBD EDGE). BOND REPAIR DOUBLER (DIA: 4") WITH FILM ADHESIVE, CURED AT 250 - [SDR UIEA2021020900262](https://openairdocs.org/sdr/UIEA2021020900262.md): Skin · cracked · Feb 6, 2021 · N404KZ · Boeing 747481F · Ailerons > CRACK - SKIN, RH WING INBD AILERON LWR SKIN OUTBD EDGE ABOUT L = 20"(
REMOVE THE DAMAGED MATERIAL AREA (L = 20", W = 1", D = 3 PLIES AT RH WING INBD AILERON LWR SKIN AFT EDGE 1", INBD EDGE 2") AND CLEAN BOND 3 REPAIR PLIES (L = 3.5", W = 4.5") USE PREPRG LAY - [SDR UIEA2021020900263](https://openairdocs.org/sdr/UIEA2021020900263.md): Skin · chafed · Feb 6, 2021 · N404KZ · Boeing 747481F · Ailerons > CHAFED - SKIN, RH WING INBD AILERON T/E WEDGE UPPER SKIN OUTBD SIDE.(
REMOVE THE DAMAGED MATERIAL AREA (L = 2", W =.25", D = 2 PLIES AT RH WING INBD AILERON T/E UPR SKIN AFT EDGE. INBD EDGE) AND CLEAN BOND 4 REPAIR PLIES (L = 6", W = 4.25") USE WET LAYUP WI - [SDR UIEA2021020900264](https://openairdocs.org/sdr/UIEA2021020900264.md): Skin · debonded · Feb 6, 2021 · N404KZ · Boeing 747481F · Rudder, Plate/Skin > DISBOND - RUDDER, LOWER RUDDER, LH SURFACE(
TRIM OUT THE DAMAGED SKIN (L = 4.5", W = 1.5", RUD STA 63, 40.5" FROM FWD EDGE) AND CLEAN BOND THE REPAIR PLIES WITH FILM ADHESIVE CURE AT 260 DEGREES F FOR 130 MINUTES. MAINTAIN A MINIMUM VACUUM OF 22 IN/HG IAW 74 - [SDR UIEA2021020900265](https://openairdocs.org/sdr/UIEA2021020900265.md): Floor Support · damaged · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage Miscellaneous Structure > BROKEN - DAMAGE ON MAIN DECK LONGITUDINAL FLOOR BEAM UPPER CHORD BETWEEN STA 1460 AND STA 1480 LBL 75.92.(
REPAIR THE BROKEN AREA IAW EI NO T2021A53M-149 REV 1. JOB COMPLETED AND COND CHK NORMAL.
) - [SDR UIEA2021020900266](https://openairdocs.org/sdr/UIEA2021020900266.md): Door Frame · cracked · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage Main, Structure > FOUND L5 DOOR CUTOUT STRUCTURE CRACK AT STA 2231 LH SIDE, WL 229(REPAIRED CRACKED AREA IAW SRM 53-60-2R-3 REPAIR 3 REV 90 AND EI NO T2021A53M-083 REV 2. JOB COMPLETED AND CONDITION CHK NORMAL.
) - [SDR UIEA2021020900267](https://openairdocs.org/sdr/UIEA2021020900267.md): Cargo Track · cracked · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage, Seat/Cargo Attach Fittings > CRACK - SUBSTITUTE SEAT TRACK, FWD CARGO COMPT CEILING AREA, MAIN DECK FLOOR STRUCTURE, STA 994, LBL 75.92.(REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-13 REPAIR 13 REV 90 AND EI NO T2021A53M-196 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.
) - [SDR UIEA2021020900268](https://openairdocs.org/sdr/UIEA2021020900268.md): Cargo Track · cracked · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage, Seat/Cargo Attach Fittings > FOUND MAIN DECK CGO SUBSTITUTE SEAT TRACK CRACK STA 995, RBL 75.92.(REPAIRED DAMAGED AREA IAW SRM 53-00-52-2R-13 REPAIR 13, REV 90, AND EI NO T2021A53M-197 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.
) - [SDR UIEA2021020900269](https://openairdocs.org/sdr/UIEA2021020900269.md): Keelbeam · corroded · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage Main, Keel > CORROSION - CHORD, INTERNAL LOWER SURFACE OF THE KEEL BEAM, STA 1338, RBL 9(ACCOMPLISHED REPAIR AREA IAW EI NO T2021A53M-152 REV 1. ORIGINAL EI ATTACHMENT TO W/O 5459875. JOB COMPLETED AND CONDITION CHK NORMAL.
) - [SDR UIEA2021020900270](https://openairdocs.org/sdr/UIEA2021020900270.md): Keelbeam · corroded · Feb 6, 2021 · N404KZ · Boeing 747481F · Fuselage Main, Keel > CORROSION - CHORD, INTERNAL LOWER SURFACE OF THE KEEL BEAM, STA 1445 RBL 9.(ACCOMPLISHED REPAIR AREA IAW EI NO T2021A53M-152 REV 1. ORIGINAL EI THAT ATTACHMENT TO WO 5459875. JOB COMPLETED AND CONDITION CHK NORMAL.
) Next page: https://openairdocs.org/aircraft/N404KZ/reports.md?page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 = 'N404KZ' AND registry_match = 'registration' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/aircraft/N404KZ/reports --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.