N911RZ
Service difficulty reports not matched to an aircraft · 60
They name N911RZ, 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 = 'N911RZ' 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 = 'N911RZ' 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 HEEA979156Transmitter · fluctuatingFLUCTUATING QTY GAUGE WHEN ABOVE 80 GALLONS.SDR HEEA968736Transceiver · defectiveFREQUENCY OUT OF TOLERANCE. PERFORMED PRELIMARY INSPECTION. ADJUSTED PULSE WIDTH AND FREQUENCY TO SPECS. FOUND RECEIVER SENSITIVITY LOW. REPLACED CR202 MIXER DIODE. HEATED AND VIBRATED UNIT. BENCH CHECK GOOD.SDR HEEA968673Inverter · noiseyINVERTER CAUSES NOISE INTERFERENCE IN #2 VHF AND NAV RADIOS.SDR HEEA968277Inverter · defectiveINVERTER CAUSES STATIC ON THE #2 VHF AND VOR.SDR HEEA968214Inverter · defectiveNOISE IN #2 VHF RADIO FREQUENCY RANGE 118-136. NEEDS MOD "A". UNIT LOCATED IN VERY HOT AREA.SDR HEEA968186Indicator · inoperativeREMOVED FOR TROUBLESHOOTING, DID NOT CURE PROBLEM. FOUND DISPLAY DIGITS INOPERATIVE. REPLACED BAD DS901 DISPLAY. CLEANED DISPLAY CONTACTS, APPLIED HUMISEAL TO PREVIOUSLY DONE HEADER MOD. UNIT BENCH CHECK GOOD.SDR HEEA968037Oil Cooler · contaminationOIL COOLER METAL CONTAMINATION.SDR HEEA968014Gyro · defectiveCOCKPIT DIR GYRO WILL NOT ALIGN OR SLAVE.SDR HEEA967695Transceiver · intermittentINTERMITTENT AS PER TOWER. REPLACED DEFECTIVE CR202 MIXER DIODE AND WEAK V101 CAVITY OSCILLATOR. ADJUSTED POWER AND FREQUENCY TO SPECS. BENCH CHECK GOOD.SDR HEEA967329Altimeter · friction errorNEEDLE HAS EXCESSIVE FRICTION ERROR.
Back to N911RZ